I get where you're coming from - so after selecting the staff member from the combo box the After Update property would tell Access to look up the rate from the appropriate column and then place it in the BudgetRate field on both the form and on tblBudgetStaff?
I changed the Control Source of the Budget Rate field on the form to tblBudgetStaff.BudgetRate and then set the After Update Expression property of the combo box to Me.BudgetRate = Me.StaffSelect.Column(1) but this gave an error which said "The expression After Update you entered as the event property setting produced the following error: The object doesn't contain the Automation object 'Me'".
I presumed that was because the name of the fields on the form don't start with "Me."?
Anyway I changed the After Update expression on the combo box to [BudgetRate] = [StaffSelect].[Column](1) but I then get an error which says "The expression After Update you entered as the event property setting produced the following error "Type mismatch".
I noticed afterwards that the combo box after update expression actually shows =[BudgetRate]=[StaffSelect].[Column](1) - I presume Access adds the "=" symbol at the beginning automatically?
There are a couple of screenshots below showing the Expression settings for the BudgetRate form field and the Combo Box After Update.
Definitely feel like I'm almost there with this problem.
Thanks again