cursor position on new record

B

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

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
 
B

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!



Dennis said:
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 said:
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.
 
D

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.

BruceM said:
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!



Dennis said:
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 said:
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.
 
B

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.

BruceM said:
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!



Dennis said:
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 said:
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.
 
B

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



Dennis said:
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.

BruceM said:
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!



Dennis said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top