VBA to open report based on listbox dropdown and button click (1 Viewer)

penchalas · Jun 13, 2019

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 · Jun 13, 2019

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

Code:

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

Minty · Jun 13, 2019

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

Make the listbox rowsource this;

Code:

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 · Jun 13, 2019

Cronk said:
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

Code:

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

Thanks Much! It worked

HiTechCoach · Jun 14, 2019

You may also find these examples helpful

Report Dialog Examples

penchalas · Jun 14, 2019

penchalas said:
Thanks Much! It worked

Can we do the same thing with combo box?

Minty · Jun 14, 2019

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

smig · Jun 14, 2019

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

enjoy

VBA to open report based on listbox dropdown and button click (1 Viewer)

penchalas

Registered User.

Cronk

Registered User.

Minty

AWF VIP

penchalas

Registered User.

HiTechCoach

Well-known member

penchalas

Registered User.

Minty

AWF VIP

smig

Registered User.

Similar threads

Users who are viewing this thread