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?
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?