Listing Reports in a Listbox

[Crackers]

I have a Form named frmClearances that lists the name, age, Club Clearing From, Club Clearing To and the Date of Clearance... this is used for my local sporting Club.

I have created reports that separate names into "Clubs Clearing From" so that each Club is aware of who has gone. The Reports are named...
clrSportingClubName

I have searched this Forum and all over as well, including Tutorials and I cannot understand how I can make a list box that contains the names of the reports so that they can be selected individually when required for each Club.

I copied the SQL for each query and placed it in the RecordSource of each Club Report so that I did not have numerous queries.

I have even copied code from other list boxes to then changed a couple of things but that has been to no avail.

Could somebody please explain to me how I do this? Thank-you very much in advance for any assistance.

 

[RuralGuy]

How about basing your ListBox on a table with two fields: the actual report name which you hide, and a Display name for the report?

 

[Idris]

I also sugguest you stick to the idea of RuralGuy otherwise you'll have restrict the list with some additional creteria - as there are ways of listing all table, queries, forms, REPORTS macros. All is possible.