Go Back   Access World Forums > Microsoft Access Discussion > Reports

Thread Tools Rate Thread Display Modes
Old 10-11-2018, 12:33 PM   #16
Newly Registered User
Join Date: Sep 2018
Posts: 103
Thanks: 18
Thanked 2 Times in 1 Post
vagues0ul is on a distinguished road
Re: Access Report Based On Multiple Criteria

Originally Posted by June7 View Post
Still have to change the combobox settings.
what changes are required now ? the code is working fine for me. If i missed something let me know

vagues0ul is offline   Reply With Quote
Old 10-11-2018, 12:34 PM   #17
Newly Registered User
June7's Avatar
Join Date: Mar 2014
Posts: 1,275
Thanks: 0
Thanked 307 Times in 307 Posts
June7 will become famous soon enough
Re: Access Report Based On Multiple Criteria

Remove ID from combobox RowSource.

Set properties:
ColumnCount: 1
ColumnWidths: nothing

After that, macro should work. Did for me. But if VBA is working (should still need to fix combobox), advise you stick with it. I don't use macros.

To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.
June7 is offline   Reply With Quote

and clause , macro builder , report , where condition

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Selecting records based on multiple criteria for a report? TBerg Modules & VBA 3 04-16-2013 12:21 PM
Open report based on multiple criteria Talismanic Modules & VBA 19 08-03-2011 07:09 AM
Creating a report from a form based on multiple criteria Moe23 Reports 8 06-10-2010 10:37 AM
Print Report from Form based on multiple criteria? Alan R Forms 5 11-17-2006 06:24 AM
Report based on multiple criteria selections Andren Reports 4 10-08-2002 03:27 PM

All times are GMT -8. The time now is 06:43 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World