displaying reports via list boxes or combo boxes

W

winnie

Please i need help with a problem i am having i have created a list box the
displays three report.My aim to to click on each form displayed on the list
box to open a report already created. How can i do this because at the
moment, when i click on the individual forms, they display the same report
which is wrong.Please what have i done wrong.I need help

winnie.
 
F

freakazeud

Hi,
I'm not understanding your request.
You are talking about reports and forms. Do you have a listbox with report
names or form names? Do you want to open reports or forms? If you have report
names in a listbox and you want to open these then you can use code like this
on the on click or after update event of the combobox:

DoCmd.OpenReport Me!lbxSelectReport, acViewPreview

lbxSelectReports would be the name of the listbox which holds the report
names.
HTH
Good luck
 
W

winnie

freakazeud said:
Hi,
I'm not understanding your request.
You are talking about reports and forms. Do you have a listbox with report
names or form names? Do you want to open reports or forms? If you have report
names in a listbox and you want to open these then you can use code like this
on the on click or after update event of the combobox:

DoCmd.OpenReport Me!lbxSelectReport, acViewPreview

lbxSelectReports would be the name of the listbox which holds the report
names.
HTH
Good luck

-- Thank you very much, i will try it out but i really ment clicking on the three different reports on the list box to display the individual report. I will also try using the combo box but if you know the solution for the listbox then that will be great.
Click to expand...
Thanks once more.
winnie.
 
W

winnie

Thanks once more it worked.

freakazeud said:
Hi,
I'm not understanding your request.
You are talking about reports and forms. Do you have a listbox with report
names or form names? Do you want to open reports or forms? If you have report
names in a listbox and you want to open these then you can use code like this
on the on click or after update event of the combobox:

DoCmd.OpenReport Me!lbxSelectReport, acViewPreview

lbxSelectReports would be the name of the listbox which holds the report
names.
HTH
Good luck
Click to expand...
 
Top