Enter Single Record

[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

 

[Brian Bastl]

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

 

[Guest]

Thanks Brian, I've never noticed that there before.

Have a great day,

Brad