Position Cursor

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,
wrote:

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

On Fri, 26 Mar 2010 16:19:01 -0700, Summing multiple fields on a form
t.com wrote:

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.
--

John W. Vinson [MVP]

In the code module behind the form being opened, place this code:

Private Sub Form_Load()
Sign_In_Date.SetFocus
End Sub

BTW, it's a very bad practice to use names that have spaces in them, as it
requires a number of different extras things, depending on what you're doing,
to handle them..

SignInDate

is much better than

Sign In Date

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201003/1

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

"fredg" wrote:

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

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
.