VBA to open report based on listbox dropdown and button click

[penchalas]

Hi All,
I have a form with a list box, button and reports


my requirement is:
1. Select the value form list box drop down
2. Click on button
3. Corresponding report should open based on list drop down selection


Ex: When i select 'customers' in list and click on button, it should open customer report


Please let me know on how to achieve this

 

[Cronk]

You can achieve this by adding the following code (modified to suit your own circumstances) the the on-click event of the form's button

select case me.YourListBox & ""
   case "Customers"
      docmd.OpenReport "YourCustomerReport"
   case "OtherReport
      docmd.Openreport "YourOtherReport"
   case ...
      ....
end select

 

[Minty]

You could populate your listbox with all reports in your database automatically ;

Make the listbox rowsource this;

SELECT MsysObjects.Name
FROM MsysObjects
WHERE (((MsysObjects.Type)=-32764))
ORDER BY MsysObjects.Name;

Then in your OnClick or Double click event

DoCmd.OpenReport Me.YourListboxName

 

[penchalas]

You can achieve this by adding the following code (modified to suit your own circumstances) the the on-click event of the form's button

select case me.YourListBox & ""
   case "Customers"
      docmd.OpenReport "YourCustomerReport"
   case "OtherReport
      docmd.Openreport "YourOtherReport"
   case ...
      ....
end select

Thanks Much! It worked

 

[HiTechCoach]

You may also find these examples helpful

Report Dialog Examples

 

[penchalas]

Thanks Much! It worked

Can we do the same thing with combo box?

 

[Minty]

Yes but its not as easy for end users to see / use.

 

[smig]

look here
https://www.access-programmers.co.uk/forums/showthread.php?p=1627184#post1627184

enjoy