Use parameterized Query in Access Form

Hi all, :bigyello:

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,

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

VB Code:

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