I have a search from that has an option group, text fields, and a checkbox where the users selects a variety of option that generates a query. If the query return at least on record a split form (form on top/datasheet on bottom) is displayed and the form has an Edit and Close button. If the query returns no records the form is still displayed except the buttons are not visible.
If I knew the result of the query and then made a decision whether to open the form or release control back to the search box that would be great. To open the form I am using VBA with the DoCmd.OpenForm(,,"MyQuery","criteria") command.
I thought about using the DLookup command and evaluate the return value for null to be used to control the program flow.
Is there a better way to do this? I am a novice to Access
Thanks
Tom
If I knew the result of the query and then made a decision whether to open the form or release control back to the search box that would be great. To open the form I am using VBA with the DoCmd.OpenForm(,,"MyQuery","criteria") command.
I thought about using the DLookup command and evaluate the return value for null to be used to control the program flow.
Is there a better way to do this? I am a novice to Access
Thanks
Tom
Query Issue
