Position Cursor

[Summing multiple fields on a form]

When I click on Add a form from the switchboard, how do I tell it where to
place the cursor. When my form loads, I would like to cursor to be in the
fieldname 'Sign In Date'

Thx

 

[fredg]

On Fri, 26 Mar 2010 16:19:01 -0700,

When I click on Add a form from the switchboard, how do I tell it where to
place the cursor. When my form loads, I would like to cursor to be in the
fieldname 'Sign In Date'

Thx

Either ....
1) Set the Tab Order for the [Sign in Date] control to position 0.
In Design View, click on View + Tab Order
When you open the form that control will have the focus.

or...
2) Code the form's Load event:
Me![Sign in Date].SetFocus
Only the first record will have [Sign in Date] the focus:

or
3) Code the Form's Current event:
Me![Sign in Date].SetFocus
Each time you go to the next record, that control will have the focus.

 

[John W. Vinson]

When I click on Add a form from the switchboard, how do I tell it where to
place the cursor. When my form loads, I would like to cursor to be in the
fieldname 'Sign In Date'

Thx

Put VBA code or a macro in the form's Load event to setfocus to the desired
control.

 

[Summing multiple fields on a form]

Thx Fredg.....As you can probably tell, I'm new and teaching myself. I
appreciate the help.

On Fri, 26 Mar 2010 16:19:01 -0700,

When I click on Add a form from the switchboard, how do I tell it where to
place the cursor. When my form loads, I would like to cursor to be in the
fieldname 'Sign In Date'

Thx

Either ....
1) Set the Tab Order for the [Sign in Date] control to position 0.
In Design View, click on View + Tab Order
When you open the form that control will have the focus.

or...
2) Code the form's Load event:
Me![Sign in Date].SetFocus
Only the first record will have [Sign in Date] the focus:

or
3) Code the Form's Current event:
Me![Sign in Date].SetFocus
Each time you go to the next record, that control will have the focus.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.