|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Automatically Update Date Field ( to be today's date) When Changing Another Filed on a Form (VB in Access ADP):
No update happens... Sub WORevNum_OnExit(Cancel As Integer) Dim Today As Date Today = Now() Me![RevDate] = Today End Sub |
|
#2
|
|||
|
|||
|
What's the type of the "Me![RevDate] "??...Plz say more about your code.
|
|
#3
|
|||
|
|||
|
Me!
for... on the Access form, there is an ID that refers to a WorkOrderID field. Basically, when changing one field (WORevNum) I want the date to be inserted automatically in a datefield (RevDate) on the record where WorkOrderID = form!frmWorkOrder!WorkOrderID |
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > Automatically Update Date ... |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|