URGENT: Selecting particular values in a combo box

[Rex]

In Northwind sample there are two tables called Categories and
Products. Both of which are related in One-to-many relationship - one
Category has many Products. I have a Form in which, I have two combo
boxes ComboBoxA (for Categories) and ComboBoxB (for Products).

My question:
When I select a particular category in ComboBoxA, I should only see the
products belonging to that particular category in ComboBoxB. Right now
I am seeing all the categories and all the products in ComboBoxA and
ComboBoxB respectively..

Any help would greatly appreciated..

Cheers

 

[Marshall Barton]

In Northwind sample there are two tables called Categories and
Products. Both of which are related in One-to-many relationship - one
Category has many Products. I have a Form in which, I have two combo
boxes ComboBoxA (for Categories) and ComboBoxB (for Products).

My question:
When I select a particular category in ComboBoxA, I should only see the
products belonging to that particular category in ComboBoxB. Right now
I am seeing all the categories and all the products in ComboBoxA and
ComboBoxB respectively..

I tried to answer this in another newsgroup.

Please don't multi post your questions.
For suggestions on how to use groups effectively, see:
http://www.mvps.org/access/netiquette.htm