VBA code to update a record

J

Jim

Hi, what is the VBA code to save changes to a record that
you currently editing with a form. (I have a button on a
form that when clicked will run a query, but I need to
have the code save changes to this record before running
the query).

email me if you could, because I don't get a change to
search this forum very often.

Thanks.....Jim
 
G

Graeme Richardson

Try placing this code behind your button

If Me.Dirty Then
Me.Dirty = false
End If

Cheers, Graeme
 

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

Dynamic Naming of Form Button 3
Trying to remove error from conflicting code 0
Adding data to MS Access from csv file 0
Word VBA - format a picture 2
Copy previous record into form field 0
Optionbutton Not working 3
Clearing combo boxes and a text box 2
Task Information Dialog Box not making duration changes to task 0

Top