Table Not Updating With Values From Controls On Form

[Guest]

I have a form that has a combo box. The combo allows the user to select an employee. Based on the selection in the combo box, two other boxes are populated with department and supervisor using queries in their respected Row Source

Their respected Control Source is a field in another table. The problem is, when the employee selection is made the other table will not automatically update with the department and supervisor displayed in the list boxes. The fields in the table are blank.

I have tried Me.Refresh in AfterUpdate in the employee combo box. I have tried Me.Refresh in the GotFocus in the next control to be selected on the form. What am I missing or doing wrong? Any help or direction you can give me will be greatly appreciated

Sincerely
Glenn White

 

[PC Datasheet]

A record is saved ONLY under one of three conditions:
1. You go to another record (Not another control!)
2. Form closes
3. Programatically

None of these three conditions have occured!

I have a form that has a combo box. The combo allows the user to select an

employee. Based on the selection in the combo box, two other boxes are
populated with department and supervisor using queries in their respected Row
Source.

Their respected Control Source is a field in another table. The problem is,

when the employee selection is made the other table will not automatically
update with the department and supervisor displayed in the list boxes. The
fields in the table are blank.

I have tried Me.Refresh in AfterUpdate in the employee combo box. I have

tried Me.Refresh in the GotFocus in the next control to be selected on the form.
What am I missing or doing wrong? Any help or direction you can give me will be
greatly appreciated.