Use macro to set value for queries

[melaniecarr23]

I have a macro which calls several queries, all based on the same piece of information.

Is there a way to ask the user for the information and use it as criteria in each of the queries used after that in the macro?

Thanks!

 

[lespaul]

Are you currently using a prompt to get the user information in each query? Use a form instead and then just reference that control name in all the queries.

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

 

[melaniecarr23]

Can you give me an idea of how to do this? I've not gotten it to work before so I was trying this instead.

 

[lespaul]

This is generally how you do it (i don't do any designing in Access)

Create a new form, "SearchForm". Put a text box on it. Name it something meaningful "SearchCriteria".

Now in ALL the queries put this:

WHERE PieceOfInformation = Forms.SearchForm.SearchCriteria

(you may need ! instead of ., I'm not real sure)

put a button on the form. Call your macro from the button.

enter information in the text box and press the button.



Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual