go to first field in form

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
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
 
thanks bunches. worked great.

Jeff Boyce said:
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

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