Combo-Box

[rockrider]

Hey everyone.

I'm currently developing a DB at work and I'm stuck with a small problem with two combo-boxes.

I have a form with some fields, two of them are two combo-box.

1st Combo-Box:

Combo-Box (Combo1) is currently feeded by the following table:

Category
Id
Description

01 - Category A
02 - Category B

2nd Combo-Box:

Combo-Box (Combo2) is currently feeded by the following table:

Products
Id
Description



01 - Product A
02 - Product B

What I would like to do is to have the second Combo-Box (Combo2) to be automatically updated depending on the values selected on Combo1.

So, If I select Category A on Combo1 I want to have the correspondent Product A on Combo2 and If I select Category B on Combo1 I want to have Product B on Combo2.

I have tried some functions but I couldn't get the job done. Can someone help me please? Many thanks

[alansidman]

Look at this site and scroll down to the tutorials on combo boxes.

http://www.datapigtechnologies.com/AccessMain.htm

Alan