auto update

[Guest]

does any one know how i can make it so that when a number (15) is inserted into a field in column A, the corresponding field in
column B always enters the date that the certain # was entered into column A.
or a good tutorial will help
im using access 2000 and the generel date/time format
thanks

 

[Reggie]

Assuming you are using a form to enter the data and that the names of your
controls and fields are what you listed in your post:

Private Sub columnA_AfterUpdate()
If Me.columnA = 15 Then
Me.columnB = Date
End If
End Sub


--
Reggie

----------

does any one know how i can make it so that when a number (15) is inserted

into a field in column A, the corresponding field in