G
Guest
I am designing a query based on parameters entered from a form. I have
entered many parameters such as:
[Forms]![FormMainSearchPopup]![apbox] or
[Forms]![FormMainSearchPopup]![apbox] is null
The query works fine, however, After I run the query and go back to design I
now have a field in the grid called [Forms]![FormMainSearchPopup]![apbox]
with multiple criteria set to "is null" and my original criteria is now
"Forms]![FormMainSearchPopup]![apbox]", missing the "or
[Forms]![FormMainSearchPopup]![apbox]"
This makes it difficult to go back and edit the query's design.
Any one have any info on this?
Thanks in advance.
Brian
entered many parameters such as:
[Forms]![FormMainSearchPopup]![apbox] or
[Forms]![FormMainSearchPopup]![apbox] is null
The query works fine, however, After I run the query and go back to design I
now have a field in the grid called [Forms]![FormMainSearchPopup]![apbox]
with multiple criteria set to "is null" and my original criteria is now
"Forms]![FormMainSearchPopup]![apbox]", missing the "or
[Forms]![FormMainSearchPopup]![apbox]"
This makes it difficult to go back and edit the query's design.
Any one have any info on this?
Thanks in advance.
Brian