SUBFORM

  • Thread starter Thread starter tree
  • Start date Start date
T

tree

I recently revised my form/subform so that
there are multiple parent/child links (4) total, however,
once complete I no longer see the information
if the non-linked fields in the subform.

Does anymore know why I can't see these other fields.
They are visible in the Table and Query, just not in
the form itsself, unless a new record is inputted.
And yes, I check the properties and "yes" is indicated
by "visible".
 
tree,

You may have mistyped or something else, but this part of
your question may make it unfathomable...

I no longer see the information
if the non-linked fields in the subform

Can you expand on this and then provide details of your
particular situation? Does kind of sound like a problem with
the Master/Child relationships, but you haven't provided any
details to sleuth it out.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
What I meant was that prior to my revisions, all field
were visible to the eye in the subform, invoice id, vendor
id, project id, invoice number, amount, allocation, and
contract id; but when I revised the first four field so
that they are linked with the parent form (which also
includes this information)the remaining field are now
blank, except when viewed in a table or query. Does this
help?
 
Most likely, when you added more Fields into the LinkMasterFields /
LinkChildFields, you made the Subform "Filter" more restrictive, i. e. less
number of Child Records meeting the LinkMasterFields / LinkChildFields
requirements. You many have ended up with an empty Recordset (filtered) for
the Subform and in this case, all Controls in the Detail Section of the
Subform "disappeared" if the Subform's RecordSource is not updateable or you
have set the AllowAdditions Property of the Subform to False.

Use the Debug window and check whether the Subform Recordset is empty or
not.
 
Thanks, I'll try that in the morning.
-----Original Message-----
Most likely, when you added more Fields into the LinkMasterFields /
LinkChildFields, you made the Subform "Filter" more restrictive, i. e. less
number of Child Records meeting the LinkMasterFields / LinkChildFields
requirements. You many have ended up with an empty Recordset (filtered) for
the Subform and in this case, all Controls in the Detail Section of the
Subform "disappeared" if the Subform's RecordSource is not updateable or you
have set the AllowAdditions Property of the Subform to False.

Use the Debug window and check whether the Subform Recordset is empty or
not.

--
HTH
Van T. Dinh
MVP (Access)








.
Click to expand...
 
Back
Top