Use parameterized Query in Access Form

[nileshhthakur2004]

Hi all,

i have one parameterized Query in Access DB when i click on that query it will ask me parameter to enter now i want to use this query in Access form and pass the paramer from control on form not manualy i have only one parameter in my parameterized Query in Access....
hi can i do this ??

thanx and Regards,

[salvelinus]

One way would be to change the query from using a parameter to getting the value from the form:

SELECT * FROM tblFoo 
WHERE fldBar = Forms!frmGetFoo!txtSomeCrit.Text