Access, how to base a query field criteria in a macro

X

x_gollumn_x

I have a form based on a query 'maindata' .
I have based the criteria in the query as one field from form
[switchboard]![hawk] or the same field from a different form
[switchboard_dept]![hawk].

If the first criteria is false (i used the switchboard_dept form) it asks
for the first criteria, is it possible to step through this without the user
seeing this? or is it possible to put the criteria in macro's?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

query to show where no data in a stated column 0
Link a text box based on drop down box with four options MS Word 365 0
Criteria in a Querie 8
Multiple Parameter Crosstab query filter by form 1
ASK Field Formatting 1
Access Query to import from Sharepoint 0
Criteria based on Check Boxes 0
Passing Criteria From a Form 1

Top