Form Load

B

Branden

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.
 
G

Gwhit

Hi Branden,

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

DoCmd.GoToRecord , , acNewRec
 
J

Jeff Conrad

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
 
B

Branden

Thanks both of you for your help that worked perfectly. Jeff I live in Bend
as well.
 
J

Jeff Conrad

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?
 
B

Branden

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!!
 
J

Jeff Conrad

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:
 
Top