cursor position on new record

[BruceM]

Sorry for the newbie Q!
I need some VERY basic info in the simplest of terms to enable me to have
the cursor positioned in the second field regardless of which field it was
on the previous record prior to going to "new record".
I found reference to "focus" & "onopen" etc but none told me exactly where
to enter the info.
I'm using Access 2003.
Unfortunately most of the tutorials & help articles that I came across don't
start from lesson one explaining it in detail.
I hope I can get some BASIC help here?
Thankyou in advance.

 

[Dennis]

Assuming you only want to go to field 2 when you select a new record,
In the On Current event of the form put this

If Me.NewRecord = True Then
[Field 2 Name].SetFocus
End If

 

[BruceM]

Mmmm, that's the bit I sort of already knew.
If I go to the form, change it to Design View & then rt click on the top of
the form & go to properties I can see on EVENT tab the one that says "On
Current".
For the life of me I can't paste in what you told me to. I'm just
lost........
Help!

Assuming you only want to go to field 2 when you select a new record,
In the On Current event of the form put this

If Me.NewRecord = True Then
[Field 2 Name].SetFocus
End If

Sorry for the newbie Q!
I need some VERY basic info in the simplest of terms to enable me to have
the cursor positioned in the second field regardless of which field it
was
on the previous record prior to going to "new record".
I found reference to "focus" & "onopen" etc but none told me exactly
where
to enter the info.
I'm using Access 2003.
Unfortunately most of the tutorials & help articles that I came across
don't
start from lesson one explaining it in detail.
I hope I can get some BASIC help here?
Thankyou in advance.

 

[Dennis]

Click in the box On Current and a drop down arrow will appear at the right
hand side. Click the arrow and select Event procedure. Then click on the
elipse (3 dots) at the right of the drop down arrow and this will put you
into the code editor for that event. Paste the code in there. Close the code
editor and save the form.

Mmmm, that's the bit I sort of already knew.
If I go to the form, change it to Design View & then rt click on the top of
the form & go to properties I can see on EVENT tab the one that says "On
Current".
For the life of me I can't paste in what you told me to. I'm just
lost........
Help!

Assuming you only want to go to field 2 when you select a new record,
In the On Current event of the form put this

If Me.NewRecord = True Then
[Field 2 Name].SetFocus
End If

Sorry for the newbie Q!
I need some VERY basic info in the simplest of terms to enable me to have
the cursor positioned in the second field regardless of which field it
was
on the previous record prior to going to "new record".
I found reference to "focus" & "onopen" etc but none told me exactly
where
to enter the info.
I'm using Access 2003.
Unfortunately most of the tutorials & help articles that I came across
don't
start from lesson one explaining it in detail.
I hope I can get some BASIC help here?
Thankyou in advance.

 

[BruceM]

I have been posting for years as BruceM. If you expect to be posting
regularly I would prefer that you choose a different screen name in order to
avoid confusion.

Mmmm, that's the bit I sort of already knew.
If I go to the form, change it to Design View & then rt click on the top
of the form & go to properties I can see on EVENT tab the one that says
"On Current".
For the life of me I can't paste in what you told me to. I'm just
lost........
Help!

Assuming you only want to go to field 2 when you select a new record,
In the On Current event of the form put this

If Me.NewRecord = True Then
[Field 2 Name].SetFocus
End If

Sorry for the newbie Q!
I need some VERY basic info in the simplest of terms to enable me to
have
the cursor positioned in the second field regardless of which field it
was
on the previous record prior to going to "new record".
I found reference to "focus" & "onopen" etc but none told me exactly
where
to enter the info.
I'm using Access 2003.
Unfortunately most of the tutorials & help articles that I came across
don't
start from lesson one explaining it in detail.
I hope I can get some BASIC help here?
Thankyou in advance.

 

[BruceM]

Thanks Dennis........ I nearly had it.
There was some code already in there & I had to paste it in between each
existing line.
Eventually got it.
I actually checked out the Northwood example but they didn't have that "fix"
either.
Once again, thanks

Click in the box On Current and a drop down arrow will appear at the right
hand side. Click the arrow and select Event procedure. Then click on the
elipse (3 dots) at the right of the drop down arrow and this will put you
into the code editor for that event. Paste the code in there. Close the
code
editor and save the form.

Mmmm, that's the bit I sort of already knew.
If I go to the form, change it to Design View & then rt click on the top
of
the form & go to properties I can see on EVENT tab the one that says "On
Current".
For the life of me I can't paste in what you told me to. I'm just
lost........
Help!

Assuming you only want to go to field 2 when you select a new record,
In the On Current event of the form put this

If Me.NewRecord = True Then
[Field 2 Name].SetFocus
End If

:

Sorry for the newbie Q!
I need some VERY basic info in the simplest of terms to enable me to
have
the cursor positioned in the second field regardless of which field it
was
on the previous record prior to going to "new record".
I found reference to "focus" & "onopen" etc but none told me exactly
where
to enter the info.
I'm using Access 2003.
Unfortunately most of the tutorials & help articles that I came across
don't
start from lesson one explaining it in detail.
I hope I can get some BASIC help here?
Thankyou in advance.