Enter Single Record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Thanks for taking the time to read my question.

I have a form through which a user enters data to a table. I only want them
to be able to enter 1 record and then have to click on a "Save" button or
something which will close the form as the record is already written to the
table. I don't want them to be able to tab through and then go to another
new record, or use page down and go to a new record. I have my settings on
the form as follows.

Allow Edits: No
Allow Deletions: No
Allow Additions: Yes
Data Entry: Yes
.....
Record Selectors: No
Navigation Buttons: No
.....
Control Box: No

The only other way I can think to do this is not have a record source, and
then when the user clicks on the "Save" button, I open a recordset and write
the data to the table. Is this the only way?

Thanks,

Brad
 
Brad,

Another way would be to set the form's cycle property to Current record, and
add a command button to close the form. This will automatically save the
record. If you want to allow the user to decide whether to save the record,
pop up a message box using the form's before update event.

Brian
 
Back
Top