VBA code to update a record

  • Thread starter Thread starter Jim
  • Start date Start date
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
 
Try placing this code behind your button

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

Cheers, Graeme
 
Back
Top