show text boxes depending on select

Posted on 2006-05-11
Last Modified: 2012-06-22
I have a form with a select list which gets it's data from a table called Products. Table Products has two fields, Product_ID and Product_Name. The list is set to display column 2 (Product_Name). I have an invisible text box on the form being populated with column 1 (Product_ID).

I also have a table called Products_To_List which two fields, Product_ID and Text_Box_Name.

Now, what I need to do is show a number of text boxes below this select, the quantity of which will be dependent upon which Product_Name they have selected.  I need to look through table Products_To_List and find all the Text_Box_Name entries which have the ID for Product_ID, and show only those text boxes, with the visible title of the text box populated by the Text_Box_Name. I also need to be able to allow the user to update fields in another table, Product_Info, by typing into the text boxes that appear.

I hope this makes sense. Thanks for any help.
Question by:pkromer
    1 Comment
    LVL 54

    Accepted Solution

    I would add a Products subform and manually link that to the Listbox.
    Access will synchronize that for you and all fields can be made visible in the subform.
    Just place a subform and after placing single-click the subform and open the properties (button with hand and white sheet)
    There select the Data tab and set the Linkage Master field to the name of your listbox and the linkage Child field to the name of the Product_ID in your subform.

    Getting the idea ?


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now