I have a form where a user has four choices to search by…. A macro runs when the “Run” icon is clicked. The macro has four conditions:
[Forms]![frm_Build_ARMS]![ACCOUNT_REFERENCE_NUMBER] Is Not Null
[Forms]![frm_Build_ARMS]![EIN] Is Not Null
[Forms]![frm_Build_ARMS]![SSN] Is Not Null
[Forms]![frm_Build_ARMS]![SS] Is Not Null
They system thinks that when the “Run” Icon is hit that the user wants to search for all four choices & gets error messages. You should only get results for whatever field is not null. Any ideas of what I'm missing? I would think the system wouldn't run that query if that field is null...
I attached a picture of my form...
Bookmarks