Update a table based on user decision

G

Guest

I have a form that contains calculated data. If the user decides that the
data is OK he can choose to save the data. If the user says to save the data
I copy the data to fields that are tied to the table but I can't get the
table to be updated. What do I need to do to make Access write the record?

Traveler
 
L

Larry Tompkins

Hi traveler,

In the event that copies your data to the text boxes add this at the end.

DoCmd.RunCommand acCmdSaveRecord

Hope This Helps.
Larry
 

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

Similar Threads

Version Updates 1
how to save variable from Form "label" to table 3
Using DSUM to get running total on a filtered form 0
data is in table but not forms 0
Prevent Update of a table related to a form based on condition 1
Access Updating inventory levels 0
Save a calculated field in a query back to a field in the table. 1
Saving Control Calculated Fields To Tables 2

Top