G
GeorgeH
In my subform, I am selecting a field relates to more than one other records.
In my subform, I am using a query to provide a drop-down list of records
based on the record I select from this field. For example, if I pick a
record "X" that contains for my next field two related records "Y" and "Z",
then when I select "X" in Field 1, in Field 2, the drop down list will offer
two options: "Y" and "Z". THis is working fine when I run the subreport.
However, when I run the Main report (containing the subreport) the subreport
query no longer works.
If this is clear can someone advise what is causing this and how to fix
Thax
In my subform, I am using a query to provide a drop-down list of records
based on the record I select from this field. For example, if I pick a
record "X" that contains for my next field two related records "Y" and "Z",
then when I select "X" in Field 1, in Field 2, the drop down list will offer
two options: "Y" and "Z". THis is working fine when I run the subreport.
However, when I run the Main report (containing the subreport) the subreport
query no longer works.
If this is clear can someone advise what is causing this and how to fix
Thax