What is the most sensible way of synchronizing a mainform with an
embedded subform.
The mainform will be used to create a new sickleave record and a
combobox will be used to select the employee for this record (EMPID).
I want the subform to display this employees sick leave history based
on the (EmpID). I tried this using child/parent linking of the subform
control, but when I am entering the new record in the mainform, I am
not able to scroll through the subform to check out the employees
history. The subform just does not accept focus from the mouse. In all
other cases, like editing, I can scroll no problem.

ANY Ideas ???

Thanks
Greg

Using the main Form to enter data, and showing a summary in a Subform
Control is not, repeat not, a good use of Subform Controls. The best use of
Subform Controls is to show the many-side of a one-to-many related Table
with the one-side shown in the main Form.

A better approach might be to have the main Form, with the Subform Control
showing the sickleave record (using Employee ID as the Link Master and Link
Child Fields). Then enter the new data in a new record in the Subform, or,
have a second Subform Control with the embedded Form in Data Entry Mode for
entering the new Record.

Larry Linson
Microsoft Office Access MVP

<codepug (AT) gmail (DOT) com> wrote

On Jan 24, 4:15*pm, "Greg (code... (AT) gmail (DOT) com)" <code... (AT) gmail (DOT) com>
wrote:
If you save your record, it won't be dirty anymore:
DoCmd.RunCommand acCmdSaveRecord
or
If Me.Dirty Then Me.Dirty = False
Would save the new record, presumably changing the situation you
described in your other thread.