Basing one combo box on another Access 2003

[Guest]

I wonder if someone can help, I am trying to follow the Microsoft guide for
basing one combo box on another so that when you choose a value in the first
box the values in the second are only those linked to the first choice. For
Example I need a Combo Box with a list of Surgeries but the second combo box
to display only the branches associated with that Surgery. I then want the
record details for that choice of branch to display in the form.

I have tried to follow the Microsoft online guide but when I have tried the
first combo works but when I click on the down arrow of the second it brings
up a prompt to enter the Branch ID?! The user will not know the branch ID's
associated with the surgery therefore I wanted the second combo box to
display the name's of the branches associated with that surgery. I have the
tables linked as:

Main Practice
PRACTICE ID (PK)

Branches
BRANCH ID (PK)
PRACTICE ID (FK)

If anyone has any tips or help it would be much appreciated!

Thanks.

 

[Guest]

Hi, Sophie.

It sounds like the query specified in the RowSource of the 2nd combo box is
returning an empty recordset. Moreover, I'm not clear about what a Practice
is--is it a physical place or business entity, or a type of surgery?

Also, where is the detail Branch data stored? It seems that there is a
one-to-many, possibly a many-to-many relationship beween Practices and
Branches, so you certainly don't want to repeat the Branch detail for every
record.

Please post a full description of each table and their relationships, and
the RowSource, ControlSource, and BoundColumn properties of each ComboBox.
If you have an AfterUpdate event in the first combo box to change the
RowSource property, please post it also. I can then better help you.

Sprinks