Combo box referencing another

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

I got close

[Forms]![Issues]![text124]


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

"jtfalk" wrote:

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" wrote:


I got close

[Forms]![Issues]![text124]


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

"jtfalk" wrote:

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