pass value to a query

[prostheticHead]

i need to have a button that will take a value and use it to open a form that takes user input from a query before its opened.


in this case a box pops up asking for a refno. is there a way i can automaticly make it so it puts in a certan refno by pressing the button on the first form?


thanks heaps!

Prosthetichead

 

[Ian Mac]

i need to have a button that will take a value and use it to open a form that takes user input from a query before its opened.


in this case a box pops up asking for a refno. is there a way i can automaticly make it so it puts in a certan refno by pressing the button on the first form?


thanks heaps!

Prosthetichead

Design the Criteria of RefNo in the Query for the second form using something like:

Forms![1stFromName]![RefNo]

If you Right-click the criteria and select Build you can locate the Control you want to take to value form.

 

[prostheticHead]

that would mean i would need to make a whole new Query and then a new form for that query

so theres no way to feed it into that little popup inputbox querys use?