If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
auto update
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 |
#2
|
|||
|
|||
auto update
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 ---------- wrote in message link.net... 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 |
Thread Tools | |
Display Modes | |
|
|