Setting the Focus in a Specific Field after Clicking "Add Record"

S

ssignore

Hello MS Online Community.
I created a database for another unit within my division with a primary data
entry form entitled Case Number Index Card Form. When the Users click on the
command button (on the Switchboard) which opens the form, they automatically
'land' in a brand new record with the cursor blinking in the Last Name field.
The users would also prefer that the cursor 'land' in the field "Last Name"
after they click the "Add Record" command button. [Currently, the cursor has
no home after "Add Record" is clicked and they need to use the mouse to put
the cursor in Last Name (which is the first field on the form.)]

I'm not well-versed in VBA; is there any way I can do this without scripting?
If not, what is the syntax needed?

Many thanks for the help!
Regards,
Simone
 

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