On Wed, 3 Feb 2010 12:07:30 -0800 (PST), Justin wrote:

Is it possible to have the subform on a main form open in add mode
while the main form is in edit mode?
I have a main form that shows the first and last name of my drivers
while the subform is for entering a date and number of hours on duty
for that date. The subform is beginning to have a large number of
entries and I have to scroll down to the last entry to begin entering
data.

Thanks for your help

Justin

Sure. Jeanette's suggestion of "Data Entry" will work.

However, it has the disadvantage that if Data Entry is set to Yes, then that's
ALL you can do - add new records - and you won't see any existing ones.

As an alternative, you can use the Load event of the subform to jump to the
new record:

Private Sub Form_Load()
DoCmd.GoToRecord, , acNewRecord
End Sub
--

John W. Vinson [MVP]