displaying reports via list boxes or combo boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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.
 
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...
 
Back
Top