Hi All,
I have a main form which is tied to the subform by employee ID. Main form is used to enter schedule variances for the employee. The subform displays the employee position and shift info from the employee detail table. Problem is when I enter the employee ID in the main form, the subform will not populate with data until I close and reopen the main form. How can I get the subform to update and be viewable as soon as the main form is populated with the employee ID? I assume I have to set an event procedure but don't know what to enter. Any help appreciated!
I have a main form which is tied to the subform by employee ID. Main form is used to enter schedule variances for the employee. The subform displays the employee position and shift info from the employee detail table. Problem is when I enter the employee ID in the main form, the subform will not populate with data until I close and reopen the main form. How can I get the subform to update and be viewable as soon as the main form is populated with the employee ID? I assume I have to set an event procedure but don't know what to enter. Any help appreciated!