List Tables in a combo box

[jl2509]

I would like to have some nested comboboxes on a form which perform as follows, and need some assistance in resolving if possible please.

I have 2 comboboxes

cboTablelist
I need to look up a list of specific table names, such as tblRefrigerator, tblCooker and tblFire etc
Each of these tables contain PK(ID) ProductDescription, Part Number, Warranty etc

cboProductList
The second combobox, displays the ProductDescription details from the contents of the specific table selected in cboTableList

The data selected here, would go into a subform



Is this possible

Thank you

 

[Micron]

The second combobox, displays the ProductDescription details from the contents of the specific table selected in cboTableList

If you are not using this combo box to make a selection that you will pass to a query or table update, or as a filter for a next-level combo box for example, then I'd say it is the wrong approach. I assume your first combo gets a list of table names from a table ("I need to look up..."), or you have created a value list for it. To me, once the selection is made, the product description details (and whatever other details) is what goes into the subform, not another combo box. Sometimes it makes sense to populate a textbox after a combo selection, but not another combo.

 

[xenou]

There is some useful tips on cascading comboboxes here:
Access Tips: Cascading Lists for Access Forms