Automatic Data Entry?

M

Mr. JYC

Hello,

I designed a form to do data entry for a table that is attached to it. What
I have noticed is when I enter data into the form (in data entry mode) it
would automatically store the data into the table instead of allowing me to
save it using the navigation keys or a control (like a button) that's
designed to save the data. The big question is, is this by design or could
the form be changed (in data entry mode) so that the data is not
automatically saved but saved using navigation buttons or a control?
 
J

John W. Vinson

Hello,

I designed a form to do data entry for a table that is attached to it. What
I have noticed is when I enter data into the form (in data entry mode) it
would automatically store the data into the table instead of allowing me to
save it using the navigation keys or a control (like a button) that's
designed to save the data. The big question is, is this by design or could
the form be changed (in data entry mode) so that the data is not
automatically saved but saved using navigation buttons or a control?

Normally data will be saved when you move off a record or close the form. You
can set the form's Cycle property to stay in the same record when you tab out
of the last field in the tab order - normally it will indeed tab into the
first field in the tab order on a new record, saving the current one.

Just change Cycle in the form's property to "Same 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