Thanks for the help in advance.
My situation is... i have a form called "Search Form" which has 2 comboBoxs with
QuoteNo (Combo41)
Engineer (Combo50)
2 Activex Date and time Picker boxes
Date Start (DTPicker5)
Date Finish (ActiveXCtl52)
1 TextBox
Delivery Number (Text43)
and a Search button (Command55)
I also have a query (VisitSheetTableQuery)
What i would like is for when information is put into the comboboxes/calender/textbox it then to open the query and filter it accordingly.
one other problem is that all the information comes from the table called "VisitSheetTable" which gets its information from other forms. However there are 3 Engineer Fields in the table so the engineer filter will have to group them sumhow?
Please help and any further information if required just ask.
Very much appreciated any help.
My situation is... i have a form called "Search Form" which has 2 comboBoxs with
QuoteNo (Combo41)
Engineer (Combo50)
2 Activex Date and time Picker boxes
Date Start (DTPicker5)
Date Finish (ActiveXCtl52)
1 TextBox
Delivery Number (Text43)
and a Search button (Command55)
I also have a query (VisitSheetTableQuery)
What i would like is for when information is put into the comboboxes/calender/textbox it then to open the query and filter it accordingly.
one other problem is that all the information comes from the table called "VisitSheetTable" which gets its information from other forms. However there are 3 Engineer Fields in the table so the engineer filter will have to group them sumhow?
Please help and any further information if required just ask.
Very much appreciated any help.
