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