creating subform keeps opening as unbound

[graeme34 via AccessMonster.com]

Hi I am trying to create a subform (Purchase details) on a master form
(purchase order), yet every time I use the subform wizard on the toobox the
subform automatically opens as an unbound form. I try to set the source
property to the query on which it is based, then when I try to link the
master/child fields I get the message cant build a link between unbound forms.
Any ideas where I am going wrong??

 

[Rick Brandt]

Hi I am trying to create a subform (Purchase details) on a master form
(purchase order), yet every time I use the subform wizard on the
toobox the subform automatically opens as an unbound form. I try to
set the source property to the query on which it is based, then when
I try to link the master/child fields I get the message cant build a
link between unbound forms. Any ideas where I am going wrong??

Don't use the builder for MasterLink and ChildLink. Just type the correct
values directly into the boxes.

 

[graeme34 via AccessMonster.com]

This works although the subform still seems to be unbound?....
This is the SQL statement of the source object query for the subform:

SELECT tblPurchaseOrderDetails.PurchaseOrderNumber, tblPurchaseOrderDetails.
ProductCode, tblProduct.Description, tblPurchaseOrderDetails.[Quantity Order],
tblPurchaseOrderDetails.Price, tblPurchaseOrderDetails.VATRate
FROM tblProduct INNER JOIN tblPurchaseOrderDetails ON tblProduct.[Product
Code] = tblPurchaseOrderDetails.ProductCode;

Yet as the subform is staying unbound I cannot seem to add text boxes for
calculated fields such as line total [Quantity Order] * Price, also I cannot
seem to access the subforms properties for turing of the record selector,
scoll bars etc.

 

[Rick Brandt]

This works although the subform still seems to be unbound?....
This is the SQL statement of the source object query for the subform:

SELECT tblPurchaseOrderDetails.PurchaseOrderNumber,
tblPurchaseOrderDetails. ProductCode, tblProduct.Description,
tblPurchaseOrderDetails.[Quantity Order],
tblPurchaseOrderDetails.Price, tblPurchaseOrderDetails.VATRate
FROM tblProduct INNER JOIN tblPurchaseOrderDetails ON
tblProduct.[Product Code] = tblPurchaseOrderDetails.ProductCode;

Yet as the subform is staying unbound I cannot seem to add text boxes
for calculated fields such as line total [Quantity Order] * Price,
also I cannot seem to access the subforms properties for turing of
the record selector, scoll bars etc.

An unbound form is one with a blank RecordSource property. If you have the
name of a query or table, or a SQL String in the RecordSource of your form
then it is NOT unbound.

The SourceObject of a subform *control* needs to be the name of a form in
your application. Youshoudl not have a SQL Statement in that property.

The SourceObject is a form name and the RecordSource of that form contains a
SQL Statement.