Combo box referencing another


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
 
Ad

Advertisements

J

jtfalk

I got close

[Forms]![Issues]![text124]


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

Advertisements

M

Mr. B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top