Combo Box Dependent on Another

[kentwoodjean]

Have viewed several FAQ's on this subject as well as other forums and although the selection from cboTeam provides the appropriate list of employees in cboEmployee, the navigation arrows at the bottom of the form do not allow me to move to a new form for a new employee. A subform is used to fill in employee scores by month. Below is the link I used to establish my combo boxes as well as my tables and raw source information. Any suggestions on what I should look for?

http://www.comeandread.com/access/tip016.htm

TblTeam
TeamID
Team

SELECT DISTINCTROW TblTeam.TeamID, TblTeam.Team FROM TblTeam;
cboTeam
1 bound column
2 column count

tbl_Employees
EmployeeID
Name
TeamID

SELECT DISTINCTROW tbl_Employees.EmployeeID, tbl_Employees.NAME FROM tbl_Employees WHERE (((Tbl_Employees.TeamID)=forms!PIOscorecard!cboTeam));

cboEmployee
1 bound column
2 column count

 

[sdk]

Hi

If you can't add a new record to a form, there is a problem with your data source for the form (if the 'parenet' or only form) or a problem between the links between child & parent if the problem is on the subform.

9 times out of 10 this is associated with primary-foreign key relationships. Take a look at the data source (query) for the subform: can you add records in the query? If you can, take a close look at the links between the two forms.

If the 2nd SQL string is your subform source, you don't need the constraint to the parent combo - that relationship is made with the links between parent and suborm (Parent Design >> Form Properties >> Link Child Properties, Link Master Properties)

Cheers

Steve

 

[kentwoodjean]

Thanks for the heads up. I will take a look at this when I return to work tomorrow and let you know.