Open Form after Last Record

  • Thread starter Thread starter RMires
  • Start date Start date
R

RMires

Is it possible to open a form starting after the last record as it would
appear when opening it in data entry mode without actually opening it in data
entry mode?
 
If you aren't going to put the form in data entry mode, and you are
attempting to move "past" the last record, what did you have in mind it
should show?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Is it possible to open a form starting after the last record as it would
appear when opening it in data entry mode without actually opening it in
data entry mode?
Click to expand...

In the Load event of the form...

DoCmd.RunCommand acCmdRecordsGoToNew

Not a good idea with a networked app in my opinion unless the table is
small as it will cause unnecessary network traffic.
 
Back
Top