The strange case of the dissapearing form

[Duncan Edment]

I have a form, that has a tab control on it. I have just changed the
Control Source of two controls on the second page of the tab and now, when I
run the form, the second page of the tab shows as a white box...there are no
controls on it.

The two controls on the second tab, are identical to two controls on the
first tab, which is how the tabbed control looked in the first place. The
only difference between the two controls, is the referencing to the controls
that they use.

Any ideas?

On an aside, does anyone know of a way to identify controls that you may
have on forms, but which are not used anywhere in the database?

Thanks & regards

Duncan

--
Newsgroups are like one big sandbox that all of us
UseNet kiddies play in with peace & harmony.

Spammers, Cross-Posters, and Lamers are the
people that pee in our big sandbox.

 

[Allen Browne]

Duncan, the first thing to try is to uncheck the Name AutoCorrect boxes
under Tools | Options | General. For info on why, see:
http://allenbrowne.com/bug-03.html

If that does not solve the problem, let's clarify that we are talking about
a bound form, and the tab control does not have subforms on these pages. (A
subform's Detail section would appear completely blank if it had no records,
and no new record could be added.)

It that is the case, are these text boxes on the page of the tab control, or
behind it? In form in design view, you could move the tab control out of the
way to see. Alternatively, in Form View you could open the Immediate Window
(Ctrl+G) and enter something like this:
? Forms!MyForm!MyTextbox.Parent.Name
If the name of the parent is the form (not the page of the tab control), the
text box is not in the tab control. Cut it (Ctrl+X), select the page of the
tab control, and paste it back in (Ctrl+V).

 

[Van T. Dinh]

See comments in-line.

HTH
Van T. Dinh
MVP (Access)

-----Original Message-----
I have a form, that has a tab control on it. I have just changed the
Control Source of two controls on the second page of the tab and now, when I
run the form, the second page of the tab shows as a white box...there are no
controls on it.

It sounds like you actually used a SubformControl and the
Controls were on the Subform and not actually on the Page
of the TabControl. If this is the case:

1. Check the SourceObject Property of the SubformControl
and make sure it has the name of the Form being used as
the "Subform".

2. If the SourceObject is correct and it (the "Subform")
is a bound Form, check and ensure that the Subform's
filtered Recordset is not empty. If the Recordset is
empty and not updateable (or the AllowAdditions is set to
False), the Detail section of the "Subform" will become
blank.

On an aside, does anyone know of a way to identify controls that you may
have on forms, but which are not used anywhere in the database?

I think there re some 3rd-part tools you can use. Perhaps:

* Total Access Analyser from FMS
* Speed Ferret Rick Fisher (?)

Search some old posts from John Vinson. He has more
details as well as links.

 

[Duncan Edment]

Allen,

Unchecked the Name AutoCorrect boxes and still no subform.

In case I didn't explain it too well--and in case I'm not understanding your
description at all (Old age, again)--what I have is as follows:

A tab control on a form. On the first TAB, I have several controls ranging
from text boxes to drop-down lists. All works fine there.

On the second TAB, I have a subform which has a query as its RecordSource.
This query merely retrieves all entries form the database, where the
employee name matches the one selected on the first TAB. The Name and two
calculated controls--the ones I was modifying--appear in the Form Header.
The Detail section contains several controls relating to the found employee,
which are repeated in a DataSheet view. The Form Footer contains several
calculated fields, which are used to update the two calculated controls in
the Form Header.

With me so far?

Everything works fine with the second TAB, until I try to make a change to
the Control Source for both calculated controls in the Form Header--the
Control Source for both is the same as the Control Source for two calculated
controls on the first TAB. At this point, viewing the second TAB results in
a blank, white form being displayed...as if no controls have been placed on
the form.

Does that make sense?

Regards

Duncan

--
Newsgroups are like one big sandbox that all of us
UseNet kiddies play in with peace & harmony.

Spammers, Cross-Posters, and Lamers are the
people that pee in our big sandbox.

 

[Allen Browne]

Hi Duncan. Okay, this might make sense of the fact that Access is having
trouble retrieving the records for the subform on the second page of your
tab control.

What's in the LinkMasterFields/LinkChildFields of that subform control?
Is it possible that you have a circular reference here, i.e. the subform is
depending on the value in the calculated controls in the form header, and
the value in the calculated controls is dependent on something else that is
also dependent on ...?

Does the status bar at the bottom of the Access window show "Calculating..."
constantly when this condition occurs?