J
John
I am trying to create some data entry forms. One such forms needs a numeric
field to default to the value of the field in the previous record. This field
is a date field. the code I am using works but the date displayed is in the
american format not the system format. Code is as follows:
Private Sub BatchNumber_AfterUpdate()
If Not IsNull(Me.BatchNumber.Value) Then
BatchNumber.DefaultValue = Me.BatchNumber.Value + 1
End If
End Sub
The other problem is adding 1 to the value of a field for subsequent
records. The code I am using only works for the 2nd record and not the 3rd
etc.
Private Sub BatchNumber_AfterUpdate()
If Not IsNull(Me.BatchNumber.Value) Then
BatchNumber.DefaultValue = Me.BatchNumber.Value + 1
End If
End Sub
I am a new user so be gentle!
Thanks John
field to default to the value of the field in the previous record. This field
is a date field. the code I am using works but the date displayed is in the
american format not the system format. Code is as follows:
Private Sub BatchNumber_AfterUpdate()
If Not IsNull(Me.BatchNumber.Value) Then
BatchNumber.DefaultValue = Me.BatchNumber.Value + 1
End If
End Sub
The other problem is adding 1 to the value of a field for subsequent
records. The code I am using only works for the 2nd record and not the 3rd
etc.
Private Sub BatchNumber_AfterUpdate()
If Not IsNull(Me.BatchNumber.Value) Then
BatchNumber.DefaultValue = Me.BatchNumber.Value + 1
End If
End Sub
I am a new user so be gentle!
Thanks John