Form Load

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

 

[Guest]

Hi Branden,

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

DoCmd.GoToRecord , , acNewRec

 

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

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

Private Sub Form_Load()
DoCmd.GoToRecord , , acNewRec
End Sub

 

[Guest]

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

 

[Jeff Conrad]

in message:

Thanks both of you for your help that worked perfectly.

Excellent, glad to help.

Jeff I live in Bend as well.

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?

 

[Guest]

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

 

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