sub form question

  • Thread starter Thread starter James
  • Start date Start date
J

James

I have a main form and 3 subforms connected to it... I
have one in the Header one in the detail and one in the
footer.... The one in the header and the footers work fine
but the one in the detail does not show...

Does anoyone know why its not showing...

Many Thanks

James
 
There are a few possiblities that I can suggest: -

1. Does the Form that you are specifying to appear in the
Sub Form exist? Check the spellings of the "Sub Form Data
Source" and the actual Sub Form..
2. When the Master Form is opened, is the Sub
Form "Disabled"? To check this, first open the master
Form in "Design View", display the properties for the Sub
Form and check the "Enabled" Box, this should be set to
yes. Check also the underlying VB Code, search
for "????.Enabled = False" and "????.Visible = False"(????
is the identity of the Sub Form), if you find any this
code then it is this code that is preventing the Sub Form
from being displayed.
The final thing that I can think of is that on the
properties of the Sub Form, there are some declarations in
the "Link Child Fields" and "Link Master Fields"
properties, if there are any declarations in these
properties, then delete them.

HTH


Tony C
 
Back
Top