Save the current record

[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

 

[Peter R. Fletcher]

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

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher

 

[Graeme Richardson]

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.

 

[Warrio]

Thanks for that!! it does help.