EDIT mode

[Musa via AccessMonster.com]

I would like to keep my db as "Add New Records" only. But I need to have the
USER to be able to go back if they don't have the information at the time to
complete the record at a later time. ( EDIT mode).

Is it possible to create an Event that would put everything in EDIT mode ,
Save the record, and then ON Exit switch to the "add new record" only ? Or,
an EDIT command button on the MAIN form?

How is this usually handled ?


Thanks

 

[John W. Vinson]

I would like to keep my db as "Add New Records" only. But I need to have the
USER to be able to go back if they don't have the information at the time to
complete the record at a later time. ( EDIT mode).

That is not a property of a database, but rather of a Form. A bit of jargon
here: a database in Access is the .mdb (or other type) file, a container for
all your tables, forms, reports, etc. A Table contains data; a Form is how the
user interacts with the data.

It sounds like you're saying that you want the user to only be able to add
records and not edit them, except that you want the user to be able to edit
them whenever they want to. Sounds a bit odd! Either they can edit record or
they cannot?

Is it possible to create an Event that would put everything in EDIT mode ,
Save the record, and then ON Exit switch to the "add new record" only ? Or,
an EDIT command button on the MAIN form?

If you really want to do it, you can put a command button on the Form with a
VBA code saying:

Private Sub cmdEdit_Click()
Me.AllowEdits = True
End Sub

Then in the Form's AfterUpdate event put

Me.AllowEdits = False