Lookup between 2 drop down

[aishnad]

Hi
I have created 2 tables -
tab1 - contains category
tab2 - Category, sub_category
In relationship, I have linked both tables with the field category.

I have a form with 2 drop down.
DD_1 - gets category list from tab1
DD_2 - based on category selected, DD_2 should query and list the relevant sub-Categories

How to do this?

 

[Montez659]

Check out this post on cascading combo boxes. Should be what you are looking for.

http://mymsaccessblog.blogspot.com/2008/03/how-to-synchronize-two-combo-boxes-on.html

 

[Pretty1996]

Also check this out. It's very good and shows step by step.

Hope this helps.

http://office.microsoft.com/en-us/access-help/basing-one-combo-box-on-another-HA001173058.aspx