Buttons in reports?

[sir_dan_mitchell]

ok here's my problem. I doubt it is possible as I have searched through previous report queries and no-one seems to have asked anything like what im about 2!

In my form I want to have a button that will open a report that is based on a query. This query will for example ask you to enter the persons name, then all the records with that persons name will appear in the report. I can do this!

However I also want to be able to view a specific record, and once found I want to press a button that will take me to that specific record in the form whilst closing the report.

I want to do it this way as it is much easier to view large amounts of data through a report rather than a form, having to manually search through one record at a time!

I have noticed that u can add buttons to a report, but then when you go to view the records you can only zoom in and out. I have also tried hyper links, but they dont work eithar!

PLEASE HELP!!!!

Dan

 

[Fizzio]

Try creating a custom toolbar for that report.

 

[cogent1]

You can create a small modal pop-up form that floats above the report and write code to trigger the desired actions from a button on that form.

 

[doulostheou]

I'm not reading this until much later, so chances are you have already done what you are going to do. But I thought I'd point out that if you use a continuous form, you are not limited to viewing one record at a time and still have all the functionality of a form.

cogent1, floating the button form over the report is a great idea. I was wanting to add an e-mail report button and I really did not want to have to create a custom menu. I will definitely be using this technique!

 

[Happy YN]

Coming in much later

How dyou add a foating form to open on top of report?
Thanks

 

[doulostheou]

It's been awhile, but I believe all I had to do is create a tiny form, just big enough for a button to fit on it. I removed the record selector, scrollbars, and navigation buttons. I then set the popup property to true. Add code to the report that opens the button form On_Open and closes it On_Close.

 

[Chasedog]

Wouldn't it be simpler to view the form in datasheet view?

 

[IgorB]

That form will be opened along with opened report and filter your report recordsource based on modal form's criteria.