469,906 Members | 2,191 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,906 developers. It's quick & easy.

Filter ComboBox Based Upon Check Box

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.
Feb 3 '15 #1
1 1149
twinnyfo
3,653 Expert Mod 2GB
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.
Feb 4 '15 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by e2biz | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.