Hi Guys (again),

Hope you can help and I'll explain this as well as I can but I've put it in general as it's a culmination of things.

I have written a call monitoring database for a call centre (all good so far), but they want historical searches (again all good). I've written the relevant queries for these so that the searches can be done for Adviser, Manager and also by a date range. However, they now want to be able to print out the current search from the screen.

The way I have done it is this. I have written the report be adding in a subreport and putting in the relevant historical search form, and then written a macro that is assigned to a button on the historical search form to print the current record.

The problem that I am having is that when they click on the button to give them the history they fill in the relevant advisor or manager name and the date range which gives them the info in form format but, when they click on the button to print the current 'screen' if you like, it asks for the information again. I know this is because the actual report is written from the same query but is there anyway that it will just print what's displayed on the screen? I don't do VBA so if it has to be done that way could you please display it as it should be inserted.

I do hope that that has made sense and that someone can at least help me, cos you're all wonderful and I've had some really excellent help in the past from this site.

Thanks in advance.

Donna x :confused: (as always)

The way i would like to help you is by means of VBA. It's a bit complicated as i dont know where to put it. Could you post the complete database with all the sensitive data in it? Or you can strip it if you must:D.

Seems to me that you want to output the results of the subform based on fields on the form. You could create your own query with use of the fields you already entered and export that to wherever you want.
You can create a query with the names of the fields in the where-clause of that query and export it.