Position Cursor

  • Thread starter Thread starter Summing multiple fields on a form
  • Start date Start date
S

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
 
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
Click to expand...

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.
 
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
Click to expand...

Put VBA code or a macro in the form's Load event to setfocus to the desired
control.
 
Thx Fredg.....As you can probably tell, I'm new and teaching myself. I
appreciate the help.

fredg said:
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
Click to expand...

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