Filter ComboBox Based Upon Check Box

[drussell10]

Using Access 2010:
Setup: I have a single table, single form with a combobox that I populate from a single column named "Device Name" in the table. When a user selects a device from the combobox it populates the remainder of the form fields associated with that device. No problem.

What I would like to do is have checkboxes (e.g. Production, Development, etc.) that when checked will filter on a column named "Status" to find records with values named "Production", "Development", etc. and show only the Device Names for those found records in the combobox.

I am doing this using VBA code.

Hopefully, that makes sense.

[twinnyfo]

drussell10,

Welcome to Bytes!

I might be a bit confused on how your table is set up. Are the "Devices" unique in the table or can the same device be listed more than once?

Where are the values "Production" and "Development" found in the table? Are these separate fields in your table or are they different values of one field?

If you could also list the fields for your table, that would be helpful. Initially, it sounds like you may need to restructure your DB Table(s) (Please see this link on DB Normalization).

But, listing your fields will give us a better idea of how to approach your problem.