Update a table based on user decision

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

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

VBA - retrieve data on last create named range from previous inserted named range 0
What are the steps to fix damaged MDF files in SQL Server? 0
Using DSUM to get running total on a filtered form 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Prevent Update of a table related to a form based on condition 1
Version Updates 1
Update Two Tables Using One Form Contents 0
Access Updating inventory levels 0

Back
Top