Novice Report question

[macattack]

Hi guys, I'm trying to make a report and I'm pretty much totally lost. I have multiple records I would like to show on a report. I have created a form to enable options (date range, serial number, word search). Given the options available, the number of records will be variable. If someone can point me in the direction of a guide I'd appreciate it.

 

[Mr. B]

Here is a link to a demo database file that is on my website. It acutally provides filtering options for a form, but hopefully you can look at how the filtering is accomplished and then apply the same concept to your report.

http://www.askdoctoraccess.com/DownloadableFiles/DemoFindAndFilterUsingComboBoxes.zip

Note: Applying optional, multiple filters is something that normally will require the use of VBA coding.

 

[macattack]

I appreciate the example but I don't think I explained what I was trying to do well enough. I need all records to show on one page (without cycling).

I played with it for a few more hours and got most of what I wanted. I'm able to query with all my search criteria except the "By Word", having some trouble with that one. Also, if I DON'T put values into the fields (such as SN or dates) the form won't load. Any ideas on how to fix that? Does it all have to be VBA or am I able to edit the SQL of the Query? It looks like I may have to throw in VBA on the report:

if chkboxSN.value = True then something about criteria = SN.value

 

[Mr. B]

macattack,

I have attached a text file that has some VBA code that hopefully will show you how to create the sql statement for filtering using values provided by the user from selections made from multiple controls.