Bit more about adding a record....

Similar to the other thread but just curious if when using a form to add a
record, how I can get the next blank record to open with the curser already
in the top entry space. At present if I stop on one record halfway through
filling out the form & then click on "new record" button, the curser on the
new form (record) is still halfway down through the list.
Also is there a key shortcut for hitting the "new record" button instead of
picking up the mouse to do it?
As you can tell I'm just trying to work things out but couldn't find these
answers anywhere.
BruceM

"BruceM" wrote in message
...
Similar to the other thread but just curious if when using a form to add a
record, how I can get the next blank record to open with the curser
already
in the top entry space. At present if I stop on one record halfway through
filling out the form & then click on "new record" button, the curser on
the
new form (record) is still halfway down through the list.
Also is there a key shortcut for hitting the "new record" button instead
of
picking up the mouse to do it?
As you can tell I'm just trying to work things out but couldn't find these
answers anywhere.
BruceM


To do the cursor thingummy you need a bit of code. In the OnCurrent event
for the form:

If Me.NewRecord Then txtSomeTextBox.SetFocus

The keyboard shortcut for a new record is Ctrl+ (that's Ctrl plus "+")

Can you be a little more precise with the cursor thingy please?
I entered it as I thought I should. I presume I change the "SomeTextBox" bit
to reflect the box I want it to go to?
OK, then I saved it but it said something about saving the macro or
something?
BruceM


"Brian" wrote in message
...
"BruceM" wrote in message
...
Similar to the other thread but just curious if when using a form to add
a
record, how I can get the next blank record to open with the curser
already
in the top entry space. At present if I stop on one record halfway
through
filling out the form & then click on "new record" button, the curser on
the
new form (record) is still halfway down through the list.
Also is there a key shortcut for hitting the "new record" button instead
of
picking up the mouse to do it?
As you can tell I'm just trying to work things out but couldn't find
these
answers anywhere.
BruceM


To do the cursor thingummy you need a bit of code. In the OnCurrent event
for the form:

If Me.NewRecord Then txtSomeTextBox.SetFocus

The keyboard shortcut for a new record is Ctrl+ (that's Ctrl plus "+")

"BruceM" wrote in message
...
Can you be a little more precise with the cursor thingy please?
I entered it as I thought I should. I presume I change the "SomeTextBox"
bit
to reflect the box I want it to go to?
OK, then I saved it but it said something about saving the macro or
something?
BruceM


Yes, you need to use the name of your textbox. Where did you type the code?
Open the properties window for the form, click the events tab, click the
button with the dots on it, and choose "Code Builder". Note where the
cursor is flashing, and paste the code right there.

Thanks Brian, I ended up getting there.
It said something about disabling debug or something but, hey, it works.
BruceM


"Brian" wrote in message
...
"BruceM" wrote in message
...
Can you be a little more precise with the cursor thingy please?
I entered it as I thought I should. I presume I change the "SomeTextBox"
bit
to reflect the box I want it to go to?
OK, then I saved it but it said something about saving the macro or
something?
BruceM


Yes, you need to use the name of your textbox. Where did you type the
code?
Open the properties window for the form, click the events tab, click the
button with the dots on it, and choose "Code Builder". Note where the
cursor is flashing, and paste the code right there.