save record

[Pass-the-reality]

On my switchboard I have "Create a Record" and "Requires Attention". When I
select "Requires Attention" a form opens that list all of the record ID's
that require a call back. If I select a record from the list box, only that
record opens. When that record opens, I have code that auto fills the date
and time. What can I add to either the Form Load or Form Open VB Code so
that upon opening that records form it will autosave the fields that populate
Date/Time without me having to type into the record 1st. Currently the form
populates the data, but will not save into the table until I close out of the
record. Once I open that record, I want it to save right then and there.

 

[strive4peace]

Currently the form populates the data, but

will not save into the table until I close out of the record.
Once I open that record, I want it to save right then and there.

after the changes are made to controls on the form, do this:

'~~~~~~~~~
me.dirty = false
'~~~~~~~~~

this will save the record



Warm Regards,
Crystal
remote programming and training

Video Tutorials on YouTube!
http://www.youtube.com/user/LearnAccessByCrystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*