Filtering a combobox based on two other fields in the form

G

George

Dear friends, need your help again.

I have a table (tbl_Applications). Two of the fields of this table named
firefighter and lookout are YES/No field. In a related table (one to many -
tbl_AppliedFor) I have a combobox based on a third table tbl_Stations (it has
an ID, a meaning and a Type (numberbyte).

When I select the firefighter (true) then I need to appear in the combobox
only those records having the Type=1, when I select Lookout in the combobox
only those records having the Type=2, when selecting both Firefighter and
Lookout I need to see all the records in the combobox.

Any help will be highly appreciated.

Thanking you in advance,

GeorgeCY
 
G

George

Sorry, no luck

Ο χÏήστης "Golfinray" έγγÏαψε:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problems filtering recordset with combobox 5
combobox problem in a simple form!SOS! 3
Autopopulate a combobox from another combobox 2
Copy record info into new form 0
Update subform with combobox change on main form 1
Filtering Query based on field values 12
Removing choices from combobox query but stilling showing for older entries 5
combobox population record dependent 4

Top