List box of available reports

[tizwaz]

i want to have a list box of all reports so that people can select the one they want.
I have managed to base it on a query that pulls the report names from the MysysObjects table but my report names aren't v user friendly eg rptEtc
Is there a way of using the report Caption instead of the Report name in such a list box?

 

[dhookom]

Create a Make Table query from your msysobjects query. Make a table named "tblReports" and then add a field for the report title. You can then remove subreports from the table. Use tblReports as your row source of the list box.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]