Subform link to another subform

[gensor]

Hello,



I'm currently "trying" to do a business management software using access and had some problems with it. This software would have client form, orders, product inventory, ...

The first one I'll describe is that in my client's form, there's an ID field. In the form, there's a subform that will list all the orders from this client linked with the client number on the main form. I want to have a second subform that is showing the products bought in the order clicked on the first subform. This second subform have to be linked with the order number in the first subform.

Right now, I'm not using VBA for this. The first subform has been configured with the assistant, I choosed in the list the field I want to link but in the second subform, the assistant doesn't allow me to link on first subform.

What am I doing wrong ?

Also, anyone have a example of project like that I could take parts of it ?

[amrut]

You need to create a fake Master field related to your first sub form and use it to relate it to second sub form. See this link for step by step process http://www.fmsinc.com/microsoftacces...edsubforms.asp

[NTC]

If sub form #1 is continuous mode (rows of data) then it is not able to have a sub form... that is just a fundamental reality of design.

Make Orders the main form; inset Customer as a sub form, and inset products as a sub form.

[gensor]

Just to be sure what you mean, I could have for example, a hide field on the form in which I could copy the Order Number of the first SubForm.
I could then use the assistant to link the second subform to this field.

At start, the subform will be empty but I could use an event on click to copy the number of the form, and then requiry the second sub.

Is it what you mean ?

[amrut]

Just to be sure what you mean, I could have for example, a hide field on the form in which I could copy the Order Number of the first SubForm.
I could then use the assistant to link the second subform to this field.

No, you need to manually enter the name of control and child field of sub form. Create a hidden textbox on Main form named txtOrderID and set its control source to the Order number field on your first sub form. In design view, select the subform2 and on the Data Tab of the Property sheet, enter txtOrderID as Link Master fields and the related OrderDetail field as Link Child fields.

[gensor]

How can I link a subform to a control on the main form ? In the assistant, there's only possibility of table field from the source of the main form

[amrut]

I already mentioned in #2, do not use assistant.

No, you need to manually enter the name of control and child field of sub form. Create a hidden textbox on Main form named txtOrderID and set its control source to the Order number field on your first sub form. In design view, select the subform2 and on the Data Tab of the Property sheet, enter txtOrderID as Link Master fields and the related OrderDetail field as Link Child fields.

[gensor]

Is it possible that this property doesn't exists in Access 2013 ? Mine is in French and I don't see anything about master or child link. This is why I'm using the assistant

[amrut]

Does above exists in Access 2013 ? In design view, select sub form2 and Press F4 to bring up the property sheet, go to Data tab