Before Update

[Nelson]

I create "serial numbers" that are a unique combination of fileds in the
record. I want to be sure these are calculated prior to moving off of a
recordset. My goal was to calculate these at the "Before Update" event, and
then move on to the next recordset. However I am not able to move off of the
current recordset when I refresh these serial numbers I am trapped inthe
"Before Update" event.

 

[Ken Snell \(MVP\)]

You've posted your question in a table design topic group, but tables do not
have events nor recordsets, so are you talking about data entry in a form?
If yes, then you need to use the form's BeforeUpdate event to do what I
think you're wanting to do.

You may want to post in the formscoding group, but otherwise give us more
details about what you're doing and what you're calculating.