Create combo box to link to value lists from 2 different tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

Im trying link from one combo box another. From the 1st combo box 1st
choice it will populate the second with values from one table and from the
1st combo box 2nd choice it will populate the second with values from another
table.

is this possible?

any help appreciated, as it will stop me going bald!

thanx
 
I needed to do the same thing with 2 sets of combo boxes on a form. I found
the article from the Access homepage of this site very helpful. The title is
Basing One Combo Box on Another. The article uses the Northwind sample
database and you can look at how the tables, code and queries are structured.
(I used a single table for all of my combo boxes and the code and queries
that the article suggests worked for me!)

http://office.microsoft.com/en-us/assistance/HA011730581033.aspx

I am by no means an expert with Access but I hope this helps, can't have you
going bald!

Jen
 
Back
Top