save record

  • Thread starter Pass-the-reality
  • Start date
P

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.
 
S

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 :)
*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top