how to parse filter from a form to a main form
Hi there,
I posted this thread few days ago, still couldn't solve it, if anyone can give me some suggestions, I will appreciate it!
I use a dialog "menu" to collect search criteria.
The "menu" dialog includes:
client(combo box)
Open_order(check box)
submit(button)
Private Sub submit_Click()
DoCmd.OpenForm "order"
End Sub
(I am wondering how can I set criteria here and parse it to the "order" form)
After the user click "submit" button in the "menu", a form named "order" should display all records which satisfy with the criteria.
In the "order" form, I had a query
My questions are as follows:
If user doesn't select anything from the combo box(I should see all the clients in the "order" form).
If the open_order isn't checked, I would see all the open orders in the "order" form.
I don't know how can I set these criteria correctly in the query under the "order" form?
flyfish
flyfish
__________________
flyfish
|