Link to a continous Form

[PNGBill]

How do you get a report to link with a field in your continuous form ?

I can get other forms to link to the record and I can get a report to link to a field on the main part of the form but it won't work on the continuous subform.

Appreciate any guidance.

 

[PNGBill]

Hi Forum, - access 2000

I have a form and can preview a statement by

[Forms]![FormFindClubMember]![ADPK] as the criteria of the query for the report.

The subform lists the individual loan records and on each record I have tried to do the same with this

[Forms]![QFindClubMembLoanQuerysubform]![LDPK]

When I click the button it asks for the value and when entered, all is well.

To me, this means the problem is between the Criteria Statement above and the form.

Is this because the form is Continuous that there is a problem identifying the field value ?

Any suggestions on a way to get a query to use a field in a continuous form ?

No problem with buttons that open other forms to only show the relevant records but not the Query/Report

 

[PNGBill]

Sorry for the double entry but I tried many times to post the original and failed hence the short version as my first post.

 

[Rich]

You have to use the full Forms reference to the subform, or add a button to the subform itself. You can use the code builder in design mode to get the correct reference

 

[PNGBill]

Thanks Rich,

The subform is continuous which means I see a number of horizontal records.

Each of these indivual records has their own buttons.

These command buttons open new forms with specific data linked to the field on the subform individual record yet the one button that opens a report is the only one not working.

 

[PNGBill]

I used a work around.
Because Forms can open. I created a form that will open on click of the command button with caption "Statement"
The click action opens the form and then the form "on open" activates the statement and this works (this form is not continuous).

As a user, you do not see the 2nd form, just the statement.