Filter Report based-on selection from Combo box in Access 2007

%3CLINGO-SUB%20id%3D%22lingo-sub-3322013%22%20slang%3D%22en-US%22%3EFilter%20Report%20based-on%20selection%20from%20Combo%20box%20in%20Access%202007%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3322013%22%20slang%3D%22en-US%22%3E%3CH2%20id%3D%22toc-hId-417705938%22%20id%3D%22toc-hId-417706060%22%3EFilter%20Report%20based-on%20selection%20from%20Combo%20box%20in%20Access%202007%3C%2FH2%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20all!%3C%2FP%3E%3CP%3EI'm%20still%20learning%20VBA%20programming%20and%20Access%20Databases.%20I've%20been%20designing%20a%20database%20for%20Membership%20Tracking%20and%20have%20several%20tables%20in%20my%20database%20which%20I%20have%20tried%20to%20normalize.%20I'm%20stuck%20at%20a%20particular%20place%20in%20my%20design%20when%20I%20need%20to%20generate%20a%20report%20for%20a%20memberID%20and%20list%20all%20of%20his%20payments%20made%20month-wise%20and%20payment%20dues.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20table%20called%20tblSubscriptions%20which%20has%20a%20date%20field%20column%20showing%20the%20date%20at%20which%20a%20particular%20payment%20was%20made%20by%20a%20member.%20What%20I%20would%20like%20to%20do%2C%20is%20to%20place%202%20combo%20boxes%20on%20a%20form%20%26nbsp%3B%2C%20one%20to%20select%20the%20MemberID%20and%20the%20other%20for%20the%20month%20(Jan%20to%20Dec).%20The%20user%20would%20select%20the%20MemberID%20from%20one%20combo%20box%20and%20a%20month%20from%20the%20other%20combo%20box%20to%20filter%20a%20report%20for%20payments%20made%20for%20the%20selected%20month%20of%20the%20particular%20memberID%20in%20question.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20to%20do%20this%20by%20the%20Macro%20Builder%2C%20but%20could%20not%20go%20beyond%20a%20particular%20step%20and%20don't%20know%20how%20I%20would%20achieve%20this%20functionality.%20I%20tried%20to%20understand%20how%20to%20do%20this%20from%20a%20lot%20of%20resources%20on%20the%20net%2C%20but%20got%20confused%20as%20there%20are%20several%20methods%20to%20achieve%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20anyone%20guide%20me%20how%20to%20achieve%20this%20functionality%20either%20on%20the%20After%20Update%20event%20of%20the%20combo%20box%20%3F%3C%2FP%3E%3CP%3EAny%20help%20is%20greatly%20appreciated.%20Thanks%20a%20lot!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3322013%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%202007%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Filter Report based-on selection from Combo box in Access 2007

 

Hi all!

I'm still learning VBA programming and Access Databases. I've been designing a database for Membership Tracking and have several tables in my database which I have tried to normalize. I'm stuck at a particular place in my design when I need to generate a report for a memberID and list all of his payments made month-wise and payment dues. 

 

I have a table called tblSubscriptions which has a date field column showing the date at which a particular payment was made by a member. What I would like to do, is to place 2 combo boxes on a form  , one to select the MemberID and the other for the month (Jan to Dec). The user would select the MemberID from one combo box and a month from the other combo box to filter a report for payments made for the selected month of the particular memberID in question.

 

I tried to do this by the Macro Builder, but could not go beyond a particular step and don't know how I would achieve this functionality. I tried to understand how to do this from a lot of resources on the net, but got confused as there are several methods to achieve this.

 

Could anyone guide me how to achieve this functionality either on the After Update event of the combo box ?

Any help is greatly appreciated. Thanks a lot!

0 Replies