Events

[Ernst Guckel]

Hello,

If I change the source object of a subform control can someone give me the
list of events that fire?? If I minimize the App then restore it is the
event list different??

Ernst.

 

[Maurice]

I think you should reverse the question and tell us what you would like to
see happen when you change the source object of the subform. I think you just
change the controlsource and continue from there. When changed you have to
work with the events of that form...

 

[Ernst Guckel]

Ok... I have a main form that changes the control source of a sub form based
on what function the userwould like to perform. The problem is that I
thought I migh have some code in one of the events that is causing the
problem. The problem is that my popup calendar does not work (Popup in
forground, it pops up in the background) until I minimize the access app then
restore it. My thinking was that there was an event that fires when I
restore the app that does not fire when changing the source of the subform
and there must be a piece of code that exists in that event allowing it to
work right.

Any ideas?

Ernst.

 

[Maurice]

Not any issues I can think of. Did you set your calendar form to Popup? That
way it's always brought in front of your form. Changing the source doesn't
affect this.

 

[Ernst Guckel]

The calendar is generated from a class module. But the same thing was
happening when I was using another calendar form(An actual form w/popup set
to yes). Like I said minimizing then restoring solves the problem until I
change the source of the subform again...


Here is the code I use to change the source of the subform...

Me.lblHeader.Caption = STR_INV
sForm = FORM_BYDATE
cldMain.SourceObject = FORM_BYDATE

Ernst.

 

[Ernst Guckel]

But this is strange... It does not happen on my personal laptop.. Just my
work machines and my wifes laptop... Running XP and Vista... All with
Offiice 03

Ernst.