Move to New Subform Record

[Kevin Sprinkel]

On opening a form with an embedded subform, I move the
focus to the subform, and then a specific subform
control. What I'd really like is to move to the bottom
and begin adding a new record. I do, however, wish to see
existing records, so I don't want to use DataEntry mode.

Can someone tell me how to do this?

TIA
Kevin Sprinkel

 

[Denny G.]

In the On Enter event of the subform control (not the
subform itself) in your main form, create an event
procedure and enter into the
procedure "DoCmd.GoToRecord , , acLast" without the
quotes.

Denny G.

 

[Denny G.]

Correction: Do the following: In the On Enter event of
the subform control (not the subform itself) on your main
form, create an event procedure and
enter "DoCmd.GoToRecord , , acNewRec" without the quotes.

Denny G.

 

[Kevin Sprinkel]

In the On Enter event of the subform control (not the

subform itself) in your main form, create an event
procedure and enter into the
procedure "DoCmd.GoToRecord , , acLast" without the
quotes.

Denny G.

Denny,

It's a beautiful thing. Thanks.

Kevin Sprinkel