Multiple Combo boxes on form (1 Viewer)

[QueryStumped]

Hello... I have been tasked to create a database. On the form I am needing to filter out records by location and type employment to bring up a record. I have the location combo box, but stumped on getting another combo box, type employment, to filter the records. I don’t have a programming background but I am willing to try anything.TIA

 

[arnelgp]

study this sample especially the query.

 

[conception_native_0123]

the WHERE code in the query is:

WHERE [field name] = forms!form_name_here!combo_box_name_here

arne's example is sort of a cascade. dependency if you will. the simplest version of what you want to do would be something like this, I would guess:

SELECT * FROM table WHERE [type employment] = forms!your_form_name_here!combo_box_name_employment type_here AND
[location] = forms!your_form_name_here!combo_box_name_location_here