Unable to scroll through data correctly

[nika.duncan]

Good day All
Need some serious help trying my best to learn as much as possible. Hope you will be able to help again.

I am working with two forms frmManager and frmMMeasures where based on selection from the combo box of frmManager of the department, position and staff member frmMMeasures is loaded where MUserLoginID and MPositionName is populated based on selection from frmManager. This is what I use to populate the MUserLoginID field for the control source " =[Forms]![frmManagers]![cboStaff] ".

My problem is when I go to the next record on the form those two fields do not change from what was picked up from the form frmManager.

I don't know how to ensure that the correct data is displayed.

Please any help will be appreciated.

 

[Cronk]

If your form frmMMeasures is a sub form of frmManager, then as the control source, use = Me.Parent!cboStaff as the control source