SubForms

[Emma]

I have a form where loans given to the clients show up. I have two nested
subforms in my form Loans Form. I'm trying to work from the outside in. I
would like the subform Loan SubForm to get the Client ID from the main table
and put it into the Subform Table Client ID, unfortunately, I don't know how
to do this. I'm confused about using a macro as the only command I've ever
used is OpenForm, but this pops up the subform, I just want the subform to
show in the main form.

 

[Scott McDaniel]

I have a form where loans given to the clients show up. I have two nested
subforms in my form Loans Form. I'm trying to work from the outside in. I
would like the subform Loan SubForm to get the Client ID from the main table
and put it into the Subform Table Client ID, unfortunately, I don't know how
to do this. I'm confused about using a macro as the only command I've ever
used is OpenForm, but this pops up the subform, I just want the subform to
show in the main form.

Have you set the Master and Child link fields correctly? These are properties of the Subform CONTROL (i.e. the control
on the parent form).

Also, you cannot enter data in to (properly related) Subform unless a record already exists in the Parent form. For
instance, if you move to a New record and then immediately try to enter data into the subform you'll get an error (since
no record exists for the Parent).

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[Dale Fye]

Emma,

Open your main form in form design view.

Click on the subform in the database window or in the navpane (2007) and
drag that form to your main form. This will drop your Loan Subform onto the
main form, with the upper left corner at the location where you drop the form.

Click on the border of the subform, and display the properties. On the data
tab, you will find properties for "Link Master Fields" and "Link Child
Fields". If you click the "..." button to the right of either of these, it
will popup the "Subform Field Linker" dialog box, which will display the
fields in the Master (main form) and Child (subform) that it things you
should use to synch the subform to the master. In your case, it looks like
this should be the ClientID

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

 

[Emma]

Hi I'm not sure what you mean by "Control" if that's the box that shows up on
the main form which outlines the subform? Anyhow I've checked and double
checked the Client ID is set in the Link Master and Link Child fields. But
the subform is still not grabbing the Client ID from the main table?

 

[Emma]

I just wanted to let you know that when I add the subform, I get Show <SQL
Statement> for each record in Main Tbl using Client ID; instead of the form
name.