J
jalbrecht
Guest
Hi, I a new user of access and am having some problems. I am creating a library type search database and have created a search form which has a number of combo and text boxes. The entered or selected values from this form are then used as field criteria in a query. The results of the query are then displayed in a results form.
The search form allows multiple criteria to be entered for each query run, for example Author, Date of Publ., Keywords, Title etc.
The problem is that when criteria is entered that does not match a record in that field, the results form comes up just as a blank form with the backgound colour etc no control boxes or form .
I would prefer if the form came up with "No Record Match" in each of the control boxes of the results form allowing the user to conduct a new search.
If any one can help it is much appreciated
Cheers
JA
The search form allows multiple criteria to be entered for each query run, for example Author, Date of Publ., Keywords, Title etc.
The problem is that when criteria is entered that does not match a record in that field, the results form comes up just as a blank form with the backgound colour etc no control boxes or form .
I would prefer if the form came up with "No Record Match" in each of the control boxes of the results form allowing the user to conduct a new search.
If any one can help it is much appreciated
Cheers
JA
