Populating a report with criteria from a combo box 1

[Herriot]

Hi Guys

I have a table of events (tbl_Events) for a training database. Users complete a form with various information, where when who cost dates etc etc.

I would like to display a report that tells me who attended what course etc

I have a parameter query that, when the report is opened, asks the user for the criteria (what Course) and then presents them with that information and this works fine. However it would be much better if the user was able to choose a course from a combo box as this would prevent typo's and such like

I have a course table as you would imagine with the usual suspects as fields (crsID; CrsName &, in this case, crsInterval (how often they have to do the course)
the parameter query has fname/sname eventid crsname (amongst others). The query's name is, imaginatively named, qry_course

If you need more information let me know and any help would be appreciated.

 

[dhookom]

IMO parameter prompts are never appropriate user interface faq701-6763. Always use controls on forms.

I almost always build a WHERE CONDITION in code to apply in a DoCmd.OpenReport method. There are some threads and FAQs in this forum that describe how to do this. Come back if you have questions.

Duane
Hook'D on Access
MS Access MVP

 

[Herriot]

Duane

many thanks for the pointer. I did a bit of research on it and I managed to get what I needed it is now up and running. So thansk again.

Peter