Bit more about adding a record....

  • Thread starter Thread starter BruceM
  • Start date Start date
B

BruceM

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 said:
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
Click to expand...

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
 
BruceM said:
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
Click to expand...

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
 
Back
Top