i have a form with a subform. the subform is continuous form. what i need is on one field to hvae the next new record to be the prev value + 1.
i find things like this
Private Sub YourNumericControl_AfterUpdate()
If Not IsNull(Me.YourNumericControl.Value) Then
YourNumericControl.DefaultValue = Me.YourNumericControl.Value
Problem is this will only work one time because this is a after update event!