URGENT: Selecting a particular values in a combo Box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rex - 21 Jan 2007 23:10 GMT

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

Reply to this Message

Marshall Barton - 21 Jan 2007 23:45 GMT

>In Northwind sample there are two tables called Categories and
>Products. Both of which are related in One-to-many relationship - one
[quoted text clipped - 6 lines]
>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

Signature

Marsh
MVP [MS Access]

Reply to this Message