Columnar Report (1 Viewer)

[d_rool]

Hi Guys

I created a form to key in data which works great. Now I want to put a button to the form which opens a report linked to the current Primary Key of the form so that they can print it out. How can I do that? At the moment when I try to create a report it shows me all the results

Or can I create a report at least which just shows one result per page. At the moment when I put a field on the report it always shows me all the results (like a table). I would rather prefer to have one result per page and you can navigate per page..... I thought it would easy but I just can't find the option.

Yes I googled already and tried for hours... really didn't find it.

thx

 

[KenHigg]

I would suggest you use a query for the report which uses the pk in the form as a parameter.

 

[d_rool]

Thank you very much for the fast reply. I managed to do a query in which i can use the PK as the paramter manually. But how can I connect it to the form??

How can I show just one result per page... see attachement what I want. I don't want a table view...

 

[KenHigg]

The parameter would look something like:

forms!myFormName!myPkFieldName

 

[d_rool]

Thanks for pointing me to the right direction.

How I finally solved it see attachement.