passing multiple values to a query

[lcross]

Ok, i have a form in wich i want to set the parameters to a query.
On the search button it will open another form to display the data.
i used this code stLinkCriteria = "[ID]=" & Me![id] And "[status]=" & "'" & Me![sta] & "'
the 1st value for status is "active"
it returns a msgbox asking the value of the parameter and a field to input the data.

I can't understant whats wrong....

 

[KenHigg]

I would simply use the flds on the first form as parameters in the second form's underlying query...

 

[lcross]

Sorry but i didn't follow you, can you be a little more explicit, please

 

[KenHigg]

Hum...

The pop up form has a recordsource, right? If you are not already doing so, make the recordsource a query and using something like 'forms!myMainform!myTextBox' as a parameter in the appropriate flds in the query...

 

[lcross]

wright, got it.
i didn't use a recordset, i used a wiserd to generate the form, so i forgot that part...
ok. tks a lot.