Save the current record

  • Thread starter Thread starter Warrio
  • Start date Start date
W

Warrio

Hello!

Is there a way to save the current record that the user is actually editing?
What I use is:
myRecordset.MoveNext
myRecordset.MovePrevious 'So the text edited can be stored effectively
into my table

is there a function that does the same action?


Thanks for any suggestion
 
Me.Dirty = False

This always forces a Save (assuming that you have actually dirtied the
record). It does, however, fail with a very unhelpful error message if
the record cannot bbe saved because of the absence of a required value
or a Relationship failure.


Hello!

Is there a way to save the current record that the user is actually editing?
What I use is:
myRecordset.MoveNext
myRecordset.MovePrevious 'So the text edited can be stored effectively
into my table

is there a function that does the same action?


Thanks for any suggestion
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Hi, referring to the form containing the record being edited you can use:
Me.Dirty = False

If you have the DAO recordset object then use:
myRecordset.Update

Hope this helps, Graeme.
 
Back
Top