Re: Table Not Updating With Values From Controls On Form

From: PC Data*** (nospam_at_nospam.spam)
Date: 03/18/04 

Date: Thu, 18 Mar 2004 22:08:59 GMT

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!

"Glenn E. White" <gwhite_sr@yahoo.com> wrote in message
news:75A474D2-C5F5-4A61-BE33-4C3490C6DDA3@microsoft.com...
> 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