So, I have an advanced form with 4 combo boxes and 1 field for a date.
In this form I'd like to be able to choose an option from one or more comboboxes and create a report of all of the records matching those criteria.
Is there a way to do this?
So, I have an advanced form with 4 combo boxes and 1 field for a date.
In this form I'd like to be able to choose an option from one or more comboboxes and create a report of all of the records matching those criteria.
Is there a way to do this?
Yes. You could use vba and a series of ifs (or select case) to determine what the user has selected, then create sql to search for the requested information.
You may find some examples at Datapig
http://www.datapigtechnologies.com/f...earchform.html
http://www.datapigtechnologies.com/f...tomfilter.html
I was following them for a little while but I don't think that's what I wanted.
Is there a way to use Advanced Filters or maybe a place I could get the VBA code for the advanced form?
Your options are a parameterized query as demonstrated by DataPig or a lot of VBA code as demonstrated by http://www.allenbrowne.com/ser-62.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thanks June. I actually found that already and I gave it a test. I wasn't so sure how I would implement it onto my DB but I will give it a try and tweak the code to my needs.
Thanks again.
Wow!
I did it! After 4 hours of working I got it to produce correct results from my criteria.
Now I need it to produce those results into a report. Any suggestions?
EDIT: Nevermind I got it!
Problem solved!