Modifying query parameters with form input

[alktrigger]

Access 2007

I've created a query that has a date parameter, but how can I arrange it that I can collect the parameters for the query before I open the query inorder to avoid the parameters messagebox?

 

[pbaldy]

Create a form with a textbox and have the query look there:

Forms!FormName.TextBoxName

 

[alktrigger]

Worked like a charm in the criteria box, can this also be applied in the Field box? I have a make-table query, and I'm trying to make a bulk entry, all with the same date. But currently I am using the same concept, but it is not grabbing the date that it is pointing to in the Field.

Field Reads:
ReferenceDate: [Forms]![Form1].[Text0]

yes I know I'm not naming anything, but this is still trial and error until I get it right.

 

[pbaldy]

I've done that in an append query, so I suppose it should also work in a make table query. Make sure focus is off the textbox before you run the query.

 

[alktrigger]

Thanks for the advice, I couldnt get it working for the make-table, but once I moved it to the append query, it worked like a charm. Thx