Sadie Hewgill
Registered User.
- Local time
- Today, 18:17
- Joined
- Oct 18, 2010
- Messages
- 52
I am making a QBF and I used the format on the ms access website to specify the criteria that will search for the filed on the form: Forms!FormName!ControlName Or Forms!FormName!ControlName Is Null
This does what I want and works for a few fields, but the Or section automatically separates itself and so there are Or criteria for all the possible combinations of fields and when they are Null. I have about 10 fields to include in the lookup query, and access is telling me that it takes too much memory to run the query. I imagine because the propagation of all those criteria combinations is huge.
I have found another suggestion of how do it on a different site, but when I tried it, it didn't perform the search:
Field: [FieldName]=[Forms]![FormName]![ControlName] or [Forms]![FormName]![ControlName] Is Null
Show: uncheck
Criteria: True
Thanks,
Sadie
This does what I want and works for a few fields, but the Or section automatically separates itself and so there are Or criteria for all the possible combinations of fields and when they are Null. I have about 10 fields to include in the lookup query, and access is telling me that it takes too much memory to run the query. I imagine because the propagation of all those criteria combinations is huge.
I have found another suggestion of how do it on a different site, but when I tried it, it didn't perform the search:
Field: [FieldName]=[Forms]![FormName]![ControlName] or [Forms]![FormName]![ControlName] Is Null
Show: uncheck
Criteria: True
Thanks,
Sadie
