On Load of form

[Andrea]

How do I set up a form so upon loading it will go to a
new record?

 

[Vítor Barbosa]

Hi,

Try this:

**** code sample ***************
Private Sub Forl_Load()

' this is the only thing you need to go to a new record every time the form
loads.
DoCmd.GoToRecord , , acNewRec

End Sub
******end of code *************

Vítor Barbosa
(Portugal)

 

[johnceef]

Good day. I found this reply because I too was attempting the same result. I tried to place your code to where I thought it should go. I did not have a change where I had hoped to have.

I am using the T&A template, Form:Time Cards. I wish to be able to open to the next "time card" (one after the last entry).

Should I try something else ?

Thank you in advance

 

[Vítor Barbosa]

Hi,

First of all I want to correct a small error:
Where I wrote "Private Sub Forl_Load()" I wanted to write "Private Sub
Form_Load()" but I think this is obvious.

Johnceef,

Can you specify where you place the code?
PS: I don't know what is this template. I use a MS Access portuguese version
and there is no T&A template.
Could you be more specific. I need more details to help you...

Vítor Barbosa

--------------------------

Good day. I found this reply because I too was attempting the same result.

I tried to place your code to where I thought it should go. I did not have a
change where I had hoped to have.

I am using the T&A template, Form:Time Cards. I wish to be able to open to

the next "time card" (one after the last entry).