Form Load

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to make it so when my form loads it starts at new record, not
sure how to accomplish this. right now it starts at record 1.
 
Hi Branden,

From the "On Open" event of your form you may want to try:

DoCmd.GoToRecord , , acNewRec
 
in message:
I would like to make it so when my form loads it starts at new record, not
sure how to accomplish this. right now it starts at record 1.
Click to expand...

Add this code to the form's Load or Open event:

Private Sub Form_Load()
DoCmd.GoToRecord , , acNewRec
End Sub
 
in message:
Thanks both of you for your help that worked perfectly.
Click to expand...

Excellent, glad to help.
Jeff I live in Bend as well.
Click to expand...

No way!!!
Serious??

A fellow Access Junkie in my town and I did not know about this?
Way cool.

We should start our own Central Oregon Access Users Group.
:-)

Is this your first time posting to this group?
 
I have posted before. I had some access in school but I haven't used it in a
long time so I am basically trying to relearn access. I am a network admin at
Hap Taylor and Sons. A central oregon users group would be awesome!!
 
No way, this is too weird!
Network admin for Hap Taylor & Sons?
Sweet!

If you'd like, you can send a message to the following address
and I'll let you know where to reach me if you need anything.

administrator
at
ernstbros
dot
com

--
Jeff Conrad
Access Junkie
Bend, Oregon

in message:
 
Back
Top