I want to make a Report Central Form with Combo boxes to select filter parameters

Lets say I want to make a form that will be my reports switchboard.  It will have command buttons for various reports and when you click them another form comes up with a combobox to select your filter criteria.  So if I click the Hours by Employee Button a form comes up with a compo box to select an employee. Etc&  I attached my database structure so you can see what I called my fields and stuff.  Ill be watching to answer any questions you might have.
Structure-TimeCard.pdf
bdgbrickAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
bdgbrick,

OK, so first you need to create your "Select a Report" form with a combobox listing your reports.
You combobox will be loaded with all the reports in your DB.

The RowSource for the combobox would look something like this:
SELECT MSysObjects.Name, MSysObjects.Type FROM MSysObjects WHERE (((MSysObjects.Name) Not Like "~*") AND ((MSysObjects.Type)=-32764));

Now there are hundreds of sites that will instruct you on how to build a "Report Criteria" menu, here is my favorite:
http://www.fontstuff.com/access/acctut19.htm
It has step by step instructions and even a sample to download.

JeffCoachman
0
 
aesmikeCommented:
was there a question in here that I missed?
0
 
wiswalldCommented:
Something like this will work for a command button for the filter for the report.

DoCmd.OpenReport "arrestreport", acViewPreview, , "[autonumber] = " & Forms!arrestreport.Autonumber
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
Rey Obrero (Capricorn1)Commented:
0
 
bdgbrickAuthor Commented:
Great website thanks!!!
Brandon
0
 
Jeffrey CoachmanMIS LiasonCommented:
capricorn1,

Yeah, I saw that too.
It looks like they simply accepted MB's, post, just to close it out.

JeffCoachman
0
 
Jeffrey CoachmanMIS LiasonCommented:
bdgbrick,

Glad I could help!

:)

JeffCoachman
0
 
Rey Obrero (Capricorn1)Commented:
nevermind, this time, he got a working solution.
0
All Courses

From novice to tech pro — start learning today.