472,142 Members | 1,189 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,142 software developers and data experts.

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 1222
3,653 Expert Mod 2GB

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 leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.