URGENT: Selecting a 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..

Take a look at these articles:

http://www.mvps.org/access/forms/frm0028.htm

http://support.microsoft.com/kb/289670/en-us