Restrict update

[snowsride]

I have created a form based on a query which shows multiple records - because the user wants to see an overview of all current records. The user can enter data into blank fields and update the underlying table by clicking on a Save button which also enters today's date into an inactive date field.

How can I lock the fields in such a way that the user is prompted to press the Save button after each entry is made i.e. I only want them to be able to enter one datum at a time before saving?

Thanks

 

[missinglinq]

How can I lock the fields in such a way that the user is prompted to press the Save button after each entry is made i.e. I only want them to be able to enter one datum at a time before saving?

By doing nothing! In Access, whenever a user leaves a Record that has had data entered or edited, and moves to another Record, closes the Form or closes Access, the Record is automatically saved! There is no need for a "Save' button.

Linq ;0)>

 

[snowsride]

Ah but...

I want the user to have to use the Save button so that it displays a prompt "Do you want to save this record" it will also append today's date to the record to be saved!

 

[missinglinq]

Ah but...

I want the user to have to use the Save button so that it displays a prompt "Do you want to save this record" it will also append today's date to the record to be saved!

That kind of code belongs in the Form_BeforeUpdate event. If you put it in a "Save" button, and a user simply moves to another Record or Closes the Form, the Record will be saved anyway, whether you/they want it to or not!

 

[newbschoolin]

I made a dummy "Save and Exit" button at the bottom of one of my forms. Was a request handed down from the higher ups.. Said they wanted a save button... Might I suggest a well placed msgbox "Saving your changes." on the form_load. Since it saves no matter


--What I used--
Private Sub cmdClose_Click()

DoCmd.Close acForm, "frmCred"
DoCmd.OpenForm "frmMain"

End Sub