recordset Edit/Update confusion

  • Thread starter Thread starter matt
  • Start date Start date
M

matt

I have a simple form bound to a table. I've created buttons for
previous record and next record. Each of these buttons first does a
recordset.Update, then goes to the previous or next record.

When do I do the recordset.Edit to make sure it gets done? Is there an
event that will always happen whenever a record first gets displayed,
whether it's from first viewing the form or from having hit a
previous/next button?

Thanks!
 
You don't need to do that at all. Any time you navigate away from a record,
it automatically updates the current record before it move to the next
record. In fact, to prevent it you would have to issue an Undo command.

The event you are asking about is the form's Current event. It fires each
time you change the current record regardless of how the change occurs.
 
Back
Top