Combo box referencing another

  • Thread starter Thread starter jtfalk
  • Start date Start date
J

jtfalk

I have 2 tables with the same column in them "Department" the first has just
the department number (DepartmentList). the scond has the department number
and stations in that department so the department may have 20 of the same
with different stations. (like department A with stations 1,2,3,4,5...)
(EquipmentList)

In the form I have the department combox to select the department number.
In the second combo I would like the box to list only those stations that
have a matching department number to the first combo box.

Any help would be appreciated.

Thanks
 
jtfalk,

Go to this link on my website:
http://www.askdoctoraccess.com/DownloadPage.htm

Scroll down just over half way down the page and look for the link:
"DemoCascadeComboBoxes.zip" click this link to download this demo. This will
show you how to do what you want.

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm


jtfalk said:
I got close

[Forms]![Issues]![text124]


I think I do have it. Does it look correct?

jtfalk said:
I have 2 tables with the same column in them "Department" the first has just
the department number (DepartmentList). the scond has the department number
and stations in that department so the department may have 20 of the same
with different stations. (like department A with stations 1,2,3,4,5...)
(EquipmentList)

In the form I have the department combox to select the department number.
In the second combo I would like the box to list only those stations that
have a matching department number to the first combo box.

Any help would be appreciated.

Thanks
Click to expand...
Click to expand...
 
Back
Top