Hi:

I have a form which is 99% of the time opened as "hidden", but
somewhere 1% of the time it pops up as "normal" and then is closed. I
am trying to find that one reference, and am having a difficult time
doing it.

Is there any debugging software or other procedure that will look at
macros macros to identify references to a specific form?

On a pretty decent application having that form pop up spoils the end
user experience!

Help appreciated

John baker

Rick Fisher's Find and Replace used to be available from
http://www.rickworld.com. I have no business connection with Rick, other
than being a long-time user of his product. It finds specified text strings
just about anywhere in your Access database application (not in the data),
but just to be certain, double-check that it looks in macros, too -- that
would not matter, nor be of interest to me, since I do not use macros, only
VBA*.

* yes, I acknowledge that for Access web apps, it is
necessary to use data macros

It's not free, but I've found it worth the relatively minor cost many times
over.

--
Larry Linson
Microsoft Office Access MVP
Co-Author, Microsoft Access Small Business Solutions, Wiley 2010

"JHB" <(E-Mail Removed)> wrote in message
news:fdd6c5f2-f296-4297-ab1d-(E-Mail Removed)...
> Hi:
>
> I have a form which is 99% of the time opened as "hidden", but
> somewhere 1% of the time it pops up as "normal" and then is closed. I
> am trying to find that one reference, and am having a difficult time
> doing it.
>
> Is there any debugging software or other procedure that will look at
> macros macros to identify references to a specific form?
>
> On a pretty decent application having that form pop up spoils the end
> user experience!
>
> Help appreciated
>
> John baker