Form Event Question

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

Guest

Hi

During Run time is their any command or way to keep track of what EVENT currently got triggered in the Form as a string so I can make it easier for 1 generic Error Handeling

I know there is Me.Name which will contain the name of the Form, so something like Me.Event or Me.EventThatJustHappened, something like that
so I can assign a string Variable to the Event that just happened

strEventThatJustHappened = ????

So no matter what Event I put the same code in, will display the appropriate Event, so I dont have to assign each event to a Global String Variable

So for..

Private Sub Form_Load(

if error then would display "Form Load

End Su

Private Sub Form_Unload(cancel As Integer
if here would display "Form_Unload
End Su

Private Sub cmboGender_KeyDown(KeyCode As Integer, Shift As Integer
if here would display "cmboGender_KeyDown
End Su

Any help would be greatly appreciated

Thank you
Jeff
 
the access form have some Properties ,you can use VBA code list it or set
it.

Function setEvent()
Dim p As Property

For Each p In Forms("formname").Properties

If Left(p.Name, 2) = "On" _

Or Left(p.Name, 5) = "After" _

Or Left(p.Name, 6) = "Before" Then

p.Value = "=msgbox('" & p.Name & "')"

End If

Next p

End Function







Jeff said:
Hi,

During Run time is their any command or way to keep track of what EVENT
Click to expand...
currently got triggered in the Form as a string so I can make it easier for
1 generic Error Handeling ?
I know there is Me.Name which will contain the name of the Form, so
Click to expand...
something like Me.Event or Me.EventThatJustHappened, something like that
so I can assign a string Variable to the Event that just happened.

strEventThatJustHappened = ?????

So no matter what Event I put the same code in, will display the
Click to expand...
appropriate Event, so I dont have to assign each event to a Global String
Variable.
 
Hi,

Thank you for the reply, but this is not what I am looking for

I just used those 3 Events as an example

What if I have 20 different Events in the Form

What I would like is some generic way to determine which Event is Currently being triggered in the Form

Thnx
Jeff
 
Back
Top