Passing a variable on a form to a pass-through query

T

tacos

I created a form where the user will type in a ID number. I want to pass
this ID number into my pass through query to bring back records only
associated with this ID. I tried the following:

ID = Forms!Form1!txtID.value

or

ID = '" & Forms!Form1!txtID.value & "'

I can't get anything to work. Is it even possible to do this?

Thanks
 
T

tacos

Thanks for the help. I had know idea about querydef, but my queries work
great now. Thanks again.
 
Top