Sub form continuous is single when opened in main form

[charlea]

Main form is single form Order
Sub form is continuous OrderDetail master link OrderID, Child OrderID


When the sub form is opened by itself it is continuous showing all Details.
When I put it in the detail section of the Order form as a sub form it shows as a single form not showing the multiple OrderDetails associated with each order.

Any suggestions?

[aytee111]

Check that you are using the correct form as the subform.

[charlea]

What do you mean by "correct form"?

[aytee111]

The name under the "source property"

[charlea]

Main form:
OrderF, Record source OrderT, Single form, Order By [OrderT].[OrderID] DESC
subform:
OrderDetailF, Record Source OrderDetailT, Continuous form, Order by [OrderDetailT].[OrderID] DESC, Link Master OrderID, Link Child OrderID

[pbaldy]

FYI, I moved post 5 from an unrelated thread to here, which is where I assume it was intended. Let me know if not.

[aytee111]

The "source object" property is the name of the subform and is on the main form, not on the subform. In the main form design view, click on the subform object and check the name under this property.

[charlea]

The "source object" property is the name of the subform and is on the main form, not on the subform. In the main form design view, click on the subform object and check the name under this property.

"source object" Main form design view>selected the subform (line around the perimeter of the sub form) went to property sheet under 'Other' name is OrderDetailF. Did I give you the information that you asked for?

[aytee111]

No, it is under "Data" and needs to be the name of the subform. It is probably correct, but before we can go further it is best to check and see that you are showing the correct form. The issue you are describing doesn't make any sense at all.

[charlea]

No, it is under "Data" and needs to be the name of the subform. It is probably correct, but before we can go further it is best to check and see that you are showing the correct form. The issue you are describing doesn't make any sense at all.

Thanks of letting me know that it is under "Data" the source Object is OrderDetailF.

[aytee111]

OK. This seems like a strange error. Next thing to try is to recreate it - delete the subform, drag it from the nav pane to the form. Leave the links blank at first. See if that helps.

If you could post a copy of your database that would help too.

[charlea]

I tried to send a zipped copy of the database. Did you receive it?

[aytee111]

No. Select "Go Advanced", then click on the attachment icon.

[charlea]

Copy.zip Let me know if you received the attachment.

[ssanfu]

PMFJI,

Main form is single form Order
Sub form is continuous OrderDetail master link OrderID, Child OrderID
When the sub form is opened by itself it is continuous showing all Details.
When I put it in the detail section of the Order form as a sub form it shows as a single form not showing the multiple OrderDetails associated with each order.

Any suggestions?

On the main form "ManageOrdersF", the subform control "OrderDetailF" is too short to display the records. Make the Height property of the sub form at least 4.75".


On a side note, I see you are displaying fields that are autonumbers on the forms. Not really a good idea......
See
Autonumbers--What they are NOT and What They Are
http://www.utteraccess.com/wiki/Autonumbers

Microsoft Access Tables: Primary Key Tips and Techniques
http://www.fmsinc.com/free/newtips/primarykey.asp