Jonny45wakey
Member
- Local time
- Today, 10:03
- Joined
- May 4, 2020
- Messages
- 40
Good Afternoon
I have a form in my Access DB called "frmSales" and it has the following fields:-
At the top of the form are 2 x comboboxes
cboYEAR which contains rowsource from table containing Years 2022 onwards
cboDept which contains the name of various departments
How best can i have the form open with no data presented then once the cboYEAR and cboDEPT are selected the fields filter the data accordingly
Any help appreciated
Jonny
I have a form in my Access DB called "frmSales" and it has the following fields:-
- Initials
- Company Name
- Job No
- Jan through to December (12 fields)
- Date
- Year
At the top of the form are 2 x comboboxes
cboYEAR which contains rowsource from table containing Years 2022 onwards
cboDept which contains the name of various departments
How best can i have the form open with no data presented then once the cboYEAR and cboDEPT are selected the fields filter the data accordingly
Any help appreciated
Jonny