Still Need Help..LinkChildFields and LinkMasterFields properties

  • Thread starter Thread starter JustMe
  • Start date Start date
J

JustMe

I am opening the subform and trying to locate this porperty listing. It's
Not There.
Could it be under a different name?

This is one of the reasons I HATE Access, but am forced to try to use it.
This is really frustrating me at this point. I'm sorry to be so presistant
but
I need to know so I can link a Subform to a combobox on my main form.
 
JustMe said:
I am opening the subform and trying to locate this porperty listing.
It's Not There.
Could it be under a different name?

This is one of the reasons I HATE Access, but am forced to try to use
it. This is really frustrating me at this point. I'm sorry to be so
presistant but
I need to know so I can link a Subform to a combobox on my main form.
Click to expand...

The Link Master Fields and Link Child Fields *do not appear* on the
property sheet of the form that will be serving as a subform. They
aren't properties of the form, they are properties of the subform
control on the main form. The subform control acts as the "window" that
will display the form object that is specified as its Source Object, and
these properties tell it how to relate that form to the main form.

So if you have a main form called "frmMain" and a subform that appears
in the Forms tab of the Database Window under the name "frmSub", then
don't bother opening frmSub in design view and looking for these
properties. That's not where they are. Instead, open frmMain in design
view and find the subform control on that form. It may be named
"frmSub", it may be named "Child1" (or some variation of "Child"+n), or
it may be named something else altogether. Click once on the subform
control, then click the Properties button on the toolbar to open the
property sheet for the subform control. You'll find these properties on
the Data tab of that property sheet.
 
These properties are not avaiable form the open subform,
but from the properties of the subform as it appears in
design mode in the main form. Just select the subform in
the main form, display the properties and look on the
Data tab.

HTH

Byron
 
I haven't seen the original posting so don't know the
whole story but....Access is capable of automatically
making forms/subforms with the necessary SQL statements to
display a record(s) on a subform based on a selection in a
combo box. First, if you have duplicates in your records
then use the "Analyze Table" selection under "Tools" in
your toolbar. Once you split your primary table (Example,
a table with name, ssn, occupation, city, zip, etc could
be split to
a "Table_Name", "Table_Occupation", "Table_City", "Table_Zi
p", etc. Once they are split you can then use the form
wizard to select (Occupation, for example) as the column
that all other tables are sorted to. Let Access make the
form/subform and then add a combo box and select "Find a
record on a form based on a value I select in my combo
box".
 
Back
Top