Finding a Form's calling Forms

[bg_ie]

Hi,

I have an Access document which I've been asked to debug and update a
little. The problem is that i can't find where one of the Forms is
being called from. In other words, I can't navigate to this form by
clicking on the various forms that lead to it. I can of course open it
via objects>>forms.

Any suggestions,

Barry.

[StrayBullet via AccessMonster.com]

I've run into this when the form in question is no longer in use, yet left
undeleted or when the form is not intended for use by the end-users, but only
by the db admin.
Is there nothing in the code or control sources referring to another form? If
not, there's a chance one of the above is the reason.

bg***@yahoo.com wrote:

>Hi,

I have an Access document which I've been asked to debug and update a
little. The problem is that i can't find where one of the Forms is
being called from. In other words, I can't navigate to this form by
clicking on the various forms that lead to it. I can of course open it
via objects>>forms.

Any suggestions,

Barry.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200705/1

[Tom van Stiphout]

On 8 May 2007 01:50:09 -0700, bg***@yahoo.com wrote:

That's not unusual. Poorly maintained databases often have objects
that are no longer in use, and objects that were never part of a menu
structure but intended to be run from the database window.

Use "Speed Ferret" or "Find and Replace" utilities to find the form by
name, and if not found, the above is likely true.
Also, you could ask users how they are using this form, and if you get
blank stares, you know enough.

-Tom.

>Hi,

I have an Access document which I've been asked to debug and update a
little. The problem is that i can't find where one of the Forms is
being called from. In other words, I can't navigate to this form by
clicking on the various forms that lead to it. I can of course open it
via objects>>forms.

Any suggestions,

Barry.

[Tim Hunter]

What i have done in this situation is:
1- Make a backup of your database
2- Rename the object in question.
3- Save and compile the code
4- Run the application.

if an error occurs, click on debug...

tim hunter

*** Sent via Developersdex http://www.developersdex.com ***

[Alan Carpenter]

There's some useful info here:
http://www.access.qbuilt.com/html/qu...l#DeadwoodTbls

Read the whole page. :-)

Cheers,
Alan Carpenter

bg***@yahoo.com wrote in
news:11**********************@u30g2000hsc.googlegr oups.com:

Hi,

I have an Access document which I've been asked to debug and update a
little. The problem is that i can't find where one of the Forms is
being called from. In other words, I can't navigate to this form by
clicking on the various forms that lead to it. I can of course open it
via objects>>forms.

Any suggestions,

Barry.