create a subform without using the wizard

[8l2255]

I do not have the wizard installed and am trying to create a subform.
I have a 'New Transaction' form and would like the productID field to
automatically update my subform, 'ProductType Subform' with the brand,
description, modelno and comments fields from the corresponding record by
productID form the product type table.

I can drop the subform into the New Transaction form but am unsure how to
link the data.

Cheers

 

[Arvin Meyer [MVP]]

I do not have the wizard installed and am trying to create a subform.
I have a 'New Transaction' form and would like the productID field to
automatically update my subform, 'ProductType Subform' with the brand,
description, modelno and comments fields from the corresponding record by
productID form the product type table.

I can drop the subform into the New Transaction form but am unsure how to
link the data.

Open the property sheet for the subform control and link 1 or more field in
the subform to 1 or more fields or controls in the main form, so for
instance, if you had frmProducts as a main form, and sfmProductDetails as a
subform:

LinkChild: ProductID
LinkMaster: ProductID

If you have the Northwind sample database installed, open the helpfile and
choose it from the sample databases. Look at the Orders/OrderDetails
form/subform.

 

[8l2255]

the quick response is greatly appreciated!

I couldn't find the link fields because I wasn't going into subform control
properties.
I was instead going into the properties from the top left square in the form.

Thanks for your help!!