By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,581 Members | 1,990 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,581 IT Pros & Developers. It's quick & easy.

Filter ComboBox Based Upon Check Box

P: 1
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
Share this Question
Share on Google+
1 Reply


twinnyfo
Expert Mod 2.5K+
P: 3,313
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.