Using Subforms

First, as advised I almost always create my subforms independently. Second, why are you using a query as the Recordsource for the main form? And does the PartID appear in that query?

Also what is the SQL for that query?

Hey Guys, I'm close but getting an error. My main form has a field, tblPartTracker.PartID and my subform has a field PartID. So, this is how I set up the subform linker.

This makes sense, I understand what its doing.

My subform looks like this in Design view.

In form view

It is not putting the PartID in the table and I get this error.

This is the Property Sheet

Any ideas?

Thanks John

Thanks Guys

I have been trying several things, I will work with this advise.

Create the subform independently of the parent form in exactly the same way as you'd create a stand-alone form. Save it, and then select it in the navigation pane and drag and drop it onto the parent form in form design view. Then position and size it as desired and, if it is to be linked to the parent form set the LinkMasterFields and LInkChildFields properties of the subform control. These are normally the primary key of the parent form's recordset, and the relevant foreign key in the subform's recordset.

Don't use the wizard and create it manually.