Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 226
  • Last Modified:

show text boxes depending on select

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.
1 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 ?


Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now