Save form record on move to next field in record

[maw230]

After I enter data into one field in a record I would like the form to save the record when I move to another field in the same record. It seems that the record is only saved when I exit it entirely. Is there a way to save a record when moving between fields in that record? Can this be done without using an Event Procedure for each field?

 

[pr2-eugin]

Without any event? That's quiet not possible.

 

[maw230]

Without any event? That's quiet not possible.

There would need to be an event for each field if I wanted this to work in each field?

 

[pr2-eugin]

Before getting deep into this. Why do you need this requirement?

 

[maw230]

So that if a user makes an edit to a record, but forgets to move to a new record their changes will still be displayed when they move from the data entry form back to the summary form. Or I suppose if they exit the form without moving to a new record, although I'm sure there are ways to force the save at that point.

I wonder if I could simply save the data entry records when the user clicks over to the summary form and then requery the summary form..

 

[pr2-eugin]

You can use Form Lost Focus method.

Although, when the Form is closed Access auto saves the information. You can set the Form Modal property to true, thus when they are entering data, they cannot wander off doing something else. If they need to move to another form, they have to use the button to close the form. Thus saving the entries made also, very less messy code.

 

[maw230]

I think that forcing them to do one thing at a time makes sense. I will check out the Modal property. Thanks!

 

[Wiz47]

So that if a user makes an edit to a record, but forgets to move to a new record their changes will still be displayed when they move from the data entry form back to the summary form. Or I suppose if they exit the form without moving to a new record, although I'm sure there are ways to force the save at that point.

I wonder if I could simply save the data entry records when the user clicks over to the summary form and then requery the summary form..

You could force the save by saving the record when you move to another form. For example:

If Me.Dirty = True Then
Me.Dirty = False
Me.YourformName.Requery
End if

 

[DemonDNF]

I've also been looking for a way to force a record to be added/saved, thanks!

Robert


(this post is to thank, and to help me refind this info quickly when I forget)