Form Query

lcross

Registered User.
Local time
Yesterday, 21:41
Joined
Aug 30, 2005
Messages
39
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]",but the problem is that i have 5 criteria from wich i can trim the query.
is there anyway to do this and pass all records to the Display FORM?
 
i try this:
stLinkCriteria = "[ID]=" & Me![id] And "[status]=" & "'" & Me![sta] & "'
and when it runs a box apears with the title of the data i entered to set the value to look, i think i'm near but there's something missing
 

Users who are viewing this thread

Back
Top Bottom