linking subforms

[Neo]

Hi

I have a main form which display customer info, I then have a subform (sub1) which displays each customers order numbers. I then have a second Subform (Sub2) which shows the contents of each order.

In am trying to link Sub2 to Sub1. In the Linking fields. I used

Forms!Main!Sub1.Form![OrderNo]

but it does not work ,

Any ideas
thanks

 

[Dembrey]

The query that "sub1" is based on should have an [order number] field (or whatever it may be called).

In the design view of form "sub1" you should link to "sub2" via this [order number] field; there is no need to reference anything on the main form.

HTH
Dembrey

 

[Neo]

HTH
Dembrey [/B][/QUOTE]

Sub one has to be linked to main form because the main form shows the customer Account Number and sub 1 shows all invoices under that Account number.

Sub 1 does have a field order number. So how do I link in to sub 2

 

[Rich]

Open sub1 on its own in design mode, add sub2 as a subform set the link there