go to first field in form

[Guest]

Hi, I am still learning, thanks for your patience.

What is best way to have cursor automatically move to first field in a form
when a new record is chosen? Not sure where to enter the condition or
exactly what syntax is. Thanks.

Was thinking to do it at the form properties "on focus" option.

 

[Guest]

Hi

Open the form in design view and select the View menu. Select the Tab order
option and move the fields around to the order that you want. If you want to
go to a specific field 1st then place this at the top of the list.

 

[Jeff Boyce]

In addition to Wayne's suggestion, if you want another approach, you could
use the OnCurrent event (fires with a new record) and put something like:
Me![TheControlYouWantFirst].SetFocus

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

thanks bunches. worked great.

In addition to Wayne's suggestion, if you want another approach, you could
use the OnCurrent event (fires with a new record) and put something like:
Me![TheControlYouWantFirst].SetFocus

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi, I am still learning, thanks for your patience.

What is best way to have cursor automatically move to first field in a
form
when a new record is chosen? Not sure where to enter the condition or
exactly what syntax is. Thanks.

Was thinking to do it at the form properties "on focus" option.