hello,
I am using a query to display my report and i want to have 2 criteria, I want the user to be able to select the values from a list insteat of writing them into a text box (use of [Please enter mpla mpla] in query>field criteria ).
I have 2 forms, each to select the value they want.In one i have an "ok" button which links to my report with "preview report" action on it and
[forms]![FrmAS].[list0] in my query criteria.
I tryed to do the same thing for the other field but it returns an error.
How can i have those two fields with criteria working together ?
thanks.
I am using a query to display my report and i want to have 2 criteria, I want the user to be able to select the values from a list insteat of writing them into a text box (use of [Please enter mpla mpla] in query>field criteria ).
I have 2 forms, each to select the value they want.In one i have an "ok" button which links to my report with "preview report" action on it and
[forms]![FrmAS].[list0] in my query criteria.
I tryed to do the same thing for the other field but it returns an error.
How can i have those two fields with criteria working together ?
thanks.
Last edited: