help autofilling query popup box

[Bonzay0]

Hi, I have a friend who wants that when he pushes a button in a form
it activate 3 queries but 2 of them asking to enter somthing He wants
that somthing will be autofilled.
how do he do that?

thanks.

 

[HiTechCoach]

I would use a form to collect the parameters for the queries. This way you can set default values and use combo boxes.

 

[Bonzay0]

i know how to do whatever i want to but i want to know the vb code that let me enter into the query popupbox (it request somthing, like a search query...) automatically!
my friend have every thing he need in the form but the query still ask for lets say a ID.

 

[HiTechCoach]

.... i want to know the vb code that let me enter into the query popupbox ...

If you referring to using a pop-up parameter in a query, AFAIK, there is NO VBA code that can be used wit\h this. It is like using Input(). I still think you need to use a form to collect the parameter value, then you can use VBA code.

 

[Bonzay0]

I'll explain slowly:
I have in the form the parameters.
the query does not see the parameters, i need a way that when the query popup the inputbox that need to be fill with the parameter it wont ask the user for it, it will be auto filled.
how do i do that?

 

[Scooterbug]

I'll explain slowly:
I have in the form the parameters.
the query does not see the parameters, i need a way that when the query popup the inputbox that need to be fill with the parameter it wont ask the user for it, it will be auto filled.
how do i do that?

If the parameters are on a form, then you can call them for the query. Go into design mode for the query, and the syntax for the criteria should be:

[forms]![FormName]![ControlName]

 

[Bonzay0]

thank you i will try that