saving event

  • Thread starter Thread starter Cameron
  • Start date Start date
C

Cameron

I have a form that I need to change how the save function works. Currently,
when a user updates the information in a textbox the record saves. Intially,
this worked well but I have been finding some records are not being saved. So
I would like to know what event I would use to save that record when a new
record is selected by the user. Or if there is a better way to save these
records. I have been finding that some data entry people negate the standard
save button also.

Suggestions?
 
I have a form that I need to change how the save function works. Currently,
when a user updates the information in a textbox the record saves. Intially,
this worked well but I have been finding some records are not being saved. So
I would like to know what event I would use to save that record when a new
record is selected by the user. Or if there is a better way to save these
records. I have been finding that some data entry people negate the standard
save button also.

Suggestions?
Click to expand...

Not sure what you're asking, Cameron. If a user "dirties" a form by entering
or changing data in any bound control, by default the dirtied record will
automatically be saved if the user moves to a different record, closes the
form, sets focus to a subform, sets focus to a parent form... almost anything
that you'ld think should save. It's possible that your users are just LOOKING
at a record without changing anything - nothing will be saved of course; or
perhaps they're typing in an UNbound textbox.

you can explicitly save a record in VBA code using either

DoCmd.RunCommand acCmdSaveRecord

or

If Me.Dirty Then
Me.Dirty = False
End If

I have no trace of an idea what you mean by "negate the standard save button"
- please explain.
 
Sorry, I think my mind is on other things as I am getting laid off by June
5th.

I think you have already answered my question. Thank you.
 
Sorry, I think my mind is on other things as I am getting laid off by June
5th.
Click to expand...

:-{(

My sympathies; good luck finding some other source of income.
I think you have already answered my question. Thank you.
Click to expand...

You're welcome.
 
Back
Top