auto update

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...
into a field in column A, the corresponding field in
 
Back
Top