R
RFJ
I've got an unbound field in a form - the value of which is picked up by a
query as a criteria. That part of the query works.
If that unbound field is empty I want the query to show all records but at
the moment it shows none.
I've been looking at posts on a similar topic but can't seem to get the code
below working.
Can SKS tell me where I'm going wrong
TIA
Rob
=([Forms].[Mainform for criteria selection].[Survey Group]) Or ("Where
[Mainform for criterial selection].[Survey Group]" Is Null)
query as a criteria. That part of the query works.
If that unbound field is empty I want the query to show all records but at
the moment it shows none.
I've been looking at posts on a similar topic but can't seem to get the code
below working.
Can SKS tell me where I'm going wrong
TIA
Rob
=([Forms].[Mainform for criteria selection].[Survey Group]) Or ("Where
[Mainform for criterial selection].[Survey Group]" Is Null)