Lookup field in a subform

Lookup field in a subform

How can I detect if a lookup field in a subform does not equal "-Select-" please?

I'm sure others must have hit this same problem but I haven't been able to find the answer as yet!

I have tried null and even ID=0 but no joy so far.

Many thanks for any advice