how do i set a field to be the same as the the previous +1

[John]

I am inputing data via a form and often the first field (BatchNumber) is
sequential. So i need to set the default value to the previous record +1. I
am using the following code BUT it only works for the next record not 3rd 4th
etc.

Private Sub BatchNumber_AfterUpdate()
BatchNumber.DefaultValue = Me.BatchNumber + 1
End Sub

PS I am new to this

JOHN

 

[luan]

I am inputing data via a form and often the first field (BatchNumber) is
sequential. So i need to set the default value to the previous record +1. I
am using the following code BUT it only works for the next record not 3rd 4th
etc.

Private Sub BatchNumber_AfterUpdate()
BatchNumber.DefaultValue = Me.BatchNumber + 1
  End Sub

PS I am new to this

JOHN

Hi !
Try use BeforeInsert event of the form
me.BatchNumber = Dmax("BatchNumber", "Table contents BatchNumber
field") + 1
Other solution: use AutoNumber for this field.
HTH
Luan

 

[Jason]

What about drop down lists in combo boxes - my afterupdates work fine even
if the combo box already contained the exact same text.