creating subform keeps opening as unbound

  • Thread starter Thread starter graeme34 via AccessMonster.com
  • Start date Start date
G

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??
 
graeme34 said:
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??
Click to expand...

Don't use the builder for MasterLink and ChildLink. Just type the correct
values directly into the boxes.
 
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.
 
graeme34 said:
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.
Click to expand...

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.
 
Back
Top