Problem After a form opens but before it loads (1 Viewer)

[Martyh]

I have a Problem that occurs between the time that a form opens ( no problem with the on open command) but before it actually loads (the on load command in which I place an "open argument" - bytBufferCurrent ). I consistently asks me for a parameter value - tblParticipant.ParticipantID - (this may be a clue but I cannot figure out how it relates) It certainly requires the tblParticipant.ParticipantID but not at this point!!! There are no other "events"...

Does anyone know how to deal with debugging Access in this sort of in-between situation? I 'm looking for clues !!

Thanks,

Marty

 

[MajP]

If not in the query anywhere see if something is in the OrderBy or FilterBy properties of the form. Sometimes stuff gets stuck in there.

 

[Gasman]

Put a breakpoint in form open and walk the code line by line?

 

[Martyh]

There is nothing in the OrderBy or FilterBy properties of the form

 

[Martyh]

Already put a breakpoint in form open ... that's how I discovered it was in between the open and the load part ... right in between ! but where is it exactly ... i still don't know!

 

[Martyh]

Whoops - you were right MajP -- I'm too embarassed to say --- looking in the wrong spot!!!

 

[MajP]

The other place this can happen is in any rowsource. So if you see this again check the combos and listboxes also.

 

[MajP]

And if you have a subform/s you have to check all of those too.

 

[Martyh]

Thanks to you both!!!