and if you wanted to find out the number of times each event fired consider putting a static varaiile in each event.. the static variable should be declared for each event so each event gets their own fluffy wuffy counter
static NoTriggers as integer
msgbox "Event:<blah>, triggered:" & notriggers & " times"
heck you coudl even extend it and build a humungous string which actaully logged waht heppen, or even write it to a logfile or text file
"event <blah> triggered at " format (now(),"HH:mm:ss") & " trigger count:" & NoTriggers
so you would get
open event triggered as 08:15:36:0
one thing to bear in mind is that you can never guarantee that all events will fire in the same sequence every time.
if you are having event problems then I'd suggest you put a debug on each event and see if its beign triggered.. if its not it could be becuase the form designer doesn't know that there is som code.. if you know your VB/VBA its quite possible to put in some code on an event, but the access runtime doens't pick it up for soem reason. to clear that fault make sure that the event is selected in the properties for the form/control.
Last edited by healdem; 08-02-07 at 06:09.
I'd rather be riding on the Tiger 800 or the Norton