Scroll 'tabular' form to bottom

  • Thread starter Thread starter Ryan
  • Start date Start date
R

Ryan

I created what the wizard calls a 'tabular ' form.
I'd like to have a command button in the footer that will
cause the same effect as scrolling to the bottom and
showing the entry point for a new record. How would I code
the event to make it do this?
 
Ryan,

A couple of suggestions...

DoCmd.GoToRecord , , acNewRec
or...
Me.DataEntry = True

One of the practical differences between the two is whether you want
to be able to scroll back up again to see previously existing records.

- Steve Schapel, Microsoft Access MVP
 
Hi Ryan,

try this lines of code in the OnClick event of the cmd button:
DoCmd.GoToRecord , , acNewRec
Me.Section(acDetail).Controls(0).SetFocus


HTH

Trias
----- Ryan wrote: -----

I created what the wizard calls a 'tabular ' form.
I'd like to have a command button in the footer that will
cause the same effect as scrolling to the bottom and
showing the entry point for a new record. How would I code
the event to make it do this?
 
Back
Top