Report

[chungtinhlak]

Hi, I am new to Access and all, I have set up a queries that contains a lot of information. Now all I want to do is make the data in this queries available for people (a report) but that's the only thing I want them to be able to see in this database and they can print. In this report, I want to have some simple selection that they can choose, like the date range for the data, the control code...

How hard would this be.

thanks in advance for all your help.

[OBP]

Well I think you might have a little trouble doing it all in a report, but you can do the selections in the Query or you can have a form where they can make those selections before displaying the Report.
That is quite easy to achieve, see this Thread, post #16 for an example of using a Form to Search or Filter the Data you want to see in a Query or form/report.
http://www.vbaexpress.com/forum/showthread.php?t=24677

[CreganTur]

There is also a related thread with an example database here (http://www.vbaexpress.com/forum/showthread.php?t=24894). It deals with filtering the records shown on a form based on user selections, but you could adapt it to a form rather easily by using the DoCmd.OpenReport method- see a related thread about that here (http://www.vbaexpress.com/forum/showthread.php?t=24898).

HTH:thumb

[chungtinhlak]

One more thing, I was looking at this: http://support.microsoft.com/kb/208529

they reference control source but I can only find control record, are these two the same?

Because when I used control record instead, it doens't work.

thanks