ntp, I'm sorry to be so slow with this, but thank you for your patience.
You said my forms Data Source should be Training Table... Is Record Source and Data Source the same? If so, yes, form's Record Source is set to Training Table.
The combo box IS bound to the EmployeeID field (from the EmployeeTable or from the TrainingTable??). Currently, it is bound to the EmployeeTable and it has the Row Source containing the following Statement:
SELECT DISTINCTROW EmployeeTable.EmployeeID, [LName] & " ," & [FName] AS Name FROM EmployeeTable ORDER BY EmployeeTable.LName, EmployeeTable.FName;
This creates the FName and LName in the combo box, I select a name and that's when the Training Table Fields should change to match the EmplName I selected. But they don't. When I put your Statement above in AfterUpdate of the EmployeeID Combo box and try to run it in the VBA Editor, it just comes up looking for the macro name. Here's a silly question for you, am I supposed to replace... where you have (combo0)in the statement, with the name of the control, (cboEmployeeID)? If not, (I mean using the combo0)then I get a Compile error saying "Invalid use of Me keyword. I changed the ME.cboEmployeeID to Me.[Name], then it comes up with a compile error on the Me.Filter.
Sorry, I'm soooo confused.
CindiN