Macro autofill parameter query Question

[ccflyer]

Is it possible for a macro to autofill in the parameter of a parameter query?

I have a parameter query, and when it runs it prompts the user for "Name" and "Date".

I want to make a macro do this automatically by retrieving the values for the parameters from text boxes on a separate form, then entering the values automatically in the parameter prompts from the query.

Any suggestions?
-Chris

 

[yellow]

In your query set your parameter to equal the fields on your other form. So instead of having the criteria set to [Name:]....Set it to:

[Forms]![FormNameContainingFields]![FieldName]

 

[ccflyer]

Hey thanks yellow, That worked!

-Chris

 

[ccflyer]

OK, I have another question now, can a macro fill in the parameter of a query?

-Chris

 

[yellow]

If you want a macro to fill in the parameters, then I'm guessing you know what those parameters are, if so then there's no need to run a parameter query...

What are you trying to achieve?

 

[ccflyer]

Woops, my mistake, I don't know why I was trying to do that when I really didn't need to.

-Chris