I have 2 tables...
Department
Team
The team table has a field (foreign key) for the Department that the team is part of.
Department_ID
Department_Name
Team_ID
Team_Name
Department_ID (FK)
The department is entered via a Combo Box on the form. This works fine.
The Team is also entered via combo box. In the Row Source I have a query which uses the value in the Department combo box to query/filter the list of Teams.
I have a Split Form. The selected Department and Team are showing fine in the Single Form but the Team Combo Box is empty (even when a value has been selected) but it appears when that record is selected.
What am I doing wrong ?
Thank you in advance for your help.
Department
Team
The team table has a field (foreign key) for the Department that the team is part of.
Department_ID
Department_Name
Team_ID
Team_Name
Department_ID (FK)
The department is entered via a Combo Box on the form. This works fine.
The Team is also entered via combo box. In the Row Source I have a query which uses the value in the Department combo box to query/filter the list of Teams.
I have a Split Form. The selected Department and Team are showing fine in the Single Form but the Team Combo Box is empty (even when a value has been selected) but it appears when that record is selected.
What am I doing wrong ?
Thank you in advance for your help.