I have 2 tables One is Called 'Lead Accountants' and contains the following fields
'ID'
'Accountant'
'Rate'
in the other table (subform) called Billing Hours i have the following fields
'ID'
'Site Number' (which links the records to the table)
'Date Worked'
'Accountant'
'Hours'
'Rate'
'Comments'
After creating the subform i change the 'Accountant' to a combo field (so i can select the accountant) I now want this to populate the 'Rate' field automatically from the first table.
I tried this:-
Private Sub CboAccID_Change()
Me.Rate.Value = Me.CboAccID.Column(1)
End Sub
with no results, but I dont think this is pointing to the right table, Any ideas?
Thanks