FirstFieldName.setfocus

Sami
and at which event we place it

Ludwig,

Most likely place will be "on open" event. But that depends on what you want to do.

It could just be a matter of setting your Tab Order correctly.

But if you want to force the Focus to jump to the first field every time you to go a new record (or change records) put that code Sami gave you in the OnCurrent event.

In a typical form as pictured below, if the tab order is Field1 to 2 to 3, navigation should work like this:

- If the cursor is in Field1 or Field 2, pressing Tab will put the cursor in the next field of the same record.
- If the cursor is in Field3 (the last field), pressing Tab will put the cursor in Field1 of the next record.
- If the cursor is in Field3 (the last field), pressing Page Down will put the cursor in Field3 of the next record.

To change the behavior of the above, you need to use coding with VBA or macros.

Yep. If you want to always set the focus on, let's say FirstName, then in the OnCurrent event of the form, all you need is:

FirstName.SetFocus

Then it doesn't matter how you get there (TAB, PgDn, click on the navigation buttons) it will always put the focus on FirstName whenever you move to a different record, or when the form opens.

Like many things, I can't think of a NON-VBA way to do this, but it's only one line of code.

Thank you so much for your reply. I believe I am using a copy of Microsoft Office 2021. This is what I purchased. In my form in design view, over to the right, I see Property sheet in between "add existing fields" and "tab order."

Under Property Sheet, when Event is clicked, nothing appears except Grey. I cannot find On Current even after looking under Format and All.

Send an Image of what you are describing.

Make sure you select "Form" at the top of the property sheet.  See picture below.

I strongly recommend you watch:

Intro to VBA
On Current

And practice those first.

Thanks to you all. All of you helped. I got it to work. Thanks again to Richard Rost. I will be studying VBA in the near future. I have the learning programs and cd.