field default value does not refresh when adding record in form

J

jrbsdad

I am adding a record in subform (continuous form view) where my field,
ConfirmCode, has the default value property control set to:
=DMax("ConfirmCode","tbBooking","ConfirmCode =" & "ConfirmCode")+1

When I insert the first record the value is set properly. On the next record
(continuous form view) inserted the value does not change.

A refresh or requery of the form does not update the ConfirmCode default
value. If I start to insert a new record in the subform and escape to cancel
it the ConfirmCode default value is updated correctly. If I change to the
next master form record the ConfirmCode value updates correctly.

I am missing something here and would appreciate any pointers on my dilemma.

Thanks, Bob B.
 
Top