New record button click then auto place cursor in 1st text field

[Peter]

I have placed a "new record" macro button (using the
wizard) on a form. I would like to have it so that once
the new record button is clicked, it opens the new record
with the cursor in the 1st text box on the form. Is there
a simple way to do this?

Thanks!

 

[fredg]

I have placed a "new record" macro button (using the
wizard) on a form. I would like to have it so that once
the new record button is clicked, it opens the new record
with the cursor in the 1st text box on the form. Is there
a simple way to do this?

Thanks!

Code the Form's current event:
Me![ControlName].SetFocus

It will always go to that control whenever you go to another record.

You could also set the Tab Order of the control to 1.

 

[Pete]

Thanks!

-----Original Message-----

I have placed a "new record" macro button (using the
wizard) on a form. I would like to have it so that once
the new record button is clicked, it opens the new record
with the cursor in the 1st text box on the form. Is there
a simple way to do this?

Thanks!

Code the Form's current event:
Me![ControlName].SetFocus

It will always go to that control whenever you go to another record.

You could also set the Tab Order of the control to 1.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal email
.