Combobox help

[Jonny45wakey]

Good Afternoon

I have a form in my Access DB called "frmSales" and it has the following fields:-

1. Initials
2. Company Name
3. Job No
4. Jan through to December (12 fields)
5. Date
6. 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

 

[bob fitz]

Can you show us a screenshot of your table Relationships

 

[Gasman]

Use those combos as criteria?
As they will not hold anything on form load, then no data will me shown.
Then Requery when they are populated.
Presumably the combos are unbound?