Set a starting field for entry on a new Record

[Guest]

I apologize that this is probably a really easy solution but it is Friday the
13th and my brain is not working. I am also new to Access.

I have a Command Button in my form that Starts a new record. When I click
on it, I would like to have a specific field (Company Name) to be ready to
enter in information. Currently, when I click on my "New Record" button, I
then have to click on the "Company Name" field. I would like to skip the
extra click after clicking on the command button and just start entering in
data. Please let me know what I need to do.

Thanks for your time.

 

[fredg]

I apologize that this is probably a really easy solution but it is Friday the
13th and my brain is not working. I am also new to Access.

I have a Command Button in my form that Starts a new record. When I click
on it, I would like to have a specific field (Company Name) to be ready to
enter in information. Currently, when I click on my "New Record" button, I
then have to click on the "Company Name" field. I would like to skip the
extra click after clicking on the command button and just start entering in
data. Please let me know what I need to do.

Thanks for your time.

Add to the command button click event:
Me![Company Name].SetFocus

A better solution might be to simply set the Form's Tab Order so that
the [Company Name] control is first in the list.
This way, any time you navigate to the next, or new, record the
[Company Name] field will get the focus.

 

[Guest]

You Rock fredg! The .setfocus was exactly what I was looking for. Thanks!

I apologize that this is probably a really easy solution but it is Friday the
13th and my brain is not working. I am also new to Access.

I have a Command Button in my form that Starts a new record. When I click
on it, I would like to have a specific field (Company Name) to be ready to
enter in information. Currently, when I click on my "New Record" button, I
then have to click on the "Company Name" field. I would like to skip the
extra click after clicking on the command button and just start entering in
data. Please let me know what I need to do.

Thanks for your time.

Add to the command button click event:
Me![Company Name].SetFocus

A better solution might be to simply set the Form's Tab Order so that
the [Company Name] control is first in the list.
This way, any time you navigate to the next, or new, record the
[Company Name] field will get the focus.