PC Review


Reply
Thread Tools Rate Thread

2 actions in one procedure

 
 
fishqqq@hotmail.com
Guest
Posts: n/a
 
      17th Aug 2011
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
2 actions in one procedure fishqqq@hotmail.com Microsoft Access Form Coding 8 20th Aug 2011 01:32 AM
Oracle stored procedure vs. functions? is not a procedure or is undefined jobs Microsoft ADO .NET 1 10th Jan 2007 02:35 PM
Can't Apply Actions Suggested Actions =?Utf-8?B?Q29hZHk=?= Spyware Discussion 6 10th Dec 2006 05:54 PM
Actions between user actions Indiana Epilepsy and Child Neurology Microsoft Excel Programming 5 23rd Aug 2006 09:22 PM
Setting object event actions in Form load procedure =?Utf-8?B?UGF0?= Microsoft Access 0 3rd Mar 2005 06:25 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:54 PM.