I've having difficulty getting 2 actions to "fit" together in the same
procedure. Can someone please offer a suggestion:
step1- update [text1] to now()
step2- compare the value of [text1] to [locktrigger] and act
accordingly.
question is how do i separate the steps so this will run correctly
Private Sub Form_Load()
Text1 = Now()
(not sure what to do at this point)
If [locktrigger] > [Text1] Then
DoCmd.OpenForm "frmLogin1"
ElseIf [locktrigger] < [Text1] Then
DoCmd.OpenForm "terms"
Else
MsgBox "Values are equal"
End If
End Sub
Any advise is greatly appreciated
|