Results 1 to 2 of 2
  1. #1
    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.


  2. #2
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    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 that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts