Thread: Populating Multiple Columns
09-27-12, 09:12 #1Registered User
- Join Date
- Sep 2012
Unanswered: Populating Multiple Columns
New to this so I hope my questions doesnt reek too much newbie-ness. I wish to populate multiple columns in a table from data in another table. Some of the columns are:- Manufacturer, Model, Revision. The manufacturer column populates correctly, however the query i am using gives all models from all manufacturers in the next column which can therefore add the possibilty of incorrect data entry. I imagine there is is simple fix that will only give the models specified in the original table against the respective manufacturers?
Please show me the error in my ways.
09-27-12, 09:44 #2Moderator
Provided Answers: 19
- Join Date
- Jun 2005
- Richmond, Virginia USA
The concept is called "cascading comboboxes" although the exact same thing applies to Listboxes with the MultiSelect Property set to None, and the code is interchangeable. Here are a couple of links with examples:
Access Tips: Cascading Lists for Access Forms
Cascading Combo/List Boxes - Microsoft Access / VBA
If you Google the term along with the "Access" you'll probably get a gazillion hits!
Linq ;0)>Hope this helps!
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007