Add Record and cursor position

G

Guest

I have a form with many fields and an Add Reord command button. When I enter
data on the form and only fill in some of the fields then press the Add
Record button
the fields on the form are cleared like I would expect but the cursor stays
at whatever field it was left on for the previous record. I tried using the
ADO add new record field and it does the same thing. Is there a way I can
set the cursor to go to the very first field when I press the Add Record?
TIA
 
G

Guest

As the last line of code in your Add Record command button's Click event:
Me.FirstControl.SetFocus
"FirstControl" would be the name of the control you want to start with for a
new record.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top