Report based on parameter (1 Viewer)

[penfold1992]

Hello again

I have been using access daily now for over a year and I have a confession.

I have never used reports... I've just never needed it!

Ok but here is the time in which I think I do need to use reports.

I have a list of companies in the database and I want to display the company and their contacts on a page. I'd like to create a dynamic report that would change based on an input from the user.
The user would select the company he wants the contact information for and then the report would put together a nice professional looking page for him to print out.

So Im hoping to have all the fields in the report and then those fields update based on a parameter that is given by the user.
Is this something that could be done or does this need to be vb coded?

 

[pbaldy]

You can base the report on a query with a criteria or use this method on a report that otherwise shows all records:

http://www.baldyweb.com/wherecondition.htm