Multiple Comboboxes on 1 form

[Halliarse]

Good Morning

I have a question relating to multiple combo boxes on one form....I have 4.

The first 3 allow the user to select a single record from 3 seperate tables. The 4th needs to be able to select records from a 4th file based on the 3 items selected in the first 3 combo boxes!

Please can someone advise how I do this?

Many thanks

Steve

 

[dhookom]

What do you mean by "file"?

select records from a 4th file

You really need to provide some additional context and tables/fields. Control names would also help. When you say "select" do you want to filter a form or subform or report based on the selections?

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[Andrzejek]

Do you mean - if you make a selection from Combo1 and Combo2, then you have different selections in Combo3 and different in Combo4?

[pre]
Combo1 Combo2 Combo3 Combo4
Earth North America USA States
Earth North America Canada Provinces
Earth North America Mexico Areas[/pre]

Have fun.

---- Andy

There is a great need for a sarcasm font.

 

[MajP]

faq702-4289