How to populate list of Combo box 2 after selecting from a list from combo box 1

[Jacko7289]

Good Day,

My form has two combo boxes where the list of second combo box is dependent on the data chosen from the first combo box. This is how the table (source of data) looks like...

Table 1: PROD
Prod (PK)
Prod_Desc

Table 2: PROD_CAT
Prod (FK)
Prod_Cat
Prod_Cat_Desc

....the tables has one to many relationship...
Anyway, The first combo box fetches the list(Prod) from PROD table directly. And what i want to happen is that after choosing from it, the second combo box should then list all the Prod_Cat under the selected Prod only.
Hope i make myself clear but in any case, any help will be greatly appreciated.

[Lysander]

Good Day,

My form has two combo boxes where the list of second combo box is dependent on the data chosen from the first combo box. This is how the table (source of data) looks like...

Table 1: PROD
Prod (PK)
Prod_Desc

Table 2: PROD_CAT
Prod (FK)
Prod_Cat
Prod_Cat_Desc

....the tables has one to many relationship...
Anyway, The first combo box fetches the list(Prod) from PROD table directly. And what i want to happen is that after choosing from it, the second combo box should then list all the Prod_Cat under the selected Prod only.
Hope i make myself clear but in any case, any help will be greatly appreciated.

In the after_update event of combo box1, you can set the rowsource of combo box 2. Something like this

cboBox2.rowsource="Select Prod_cat from [table 2] where prod=" & cboBox1 & ";"
 

if prod is text and not a number, then use & chr(34) & cboBox1 & chr(34) &

[NeoPa]

Hi Jacko.

There is an article (Example Filtering on a Form.) that takes you through all this.