Similar Form for Report Generation

[brsawvel]

Hello All,

I'm sure this has been covered before so I apologize ahead of time if someone has to submit a link to a previous thread...

I have a basic form that displays records. How do create a form that looks exactly like the first form but is used as a query to tell a report which records to display when a "send to report" button is selected?

For example:

txtboxName= not selected
TxtboxAnimal= Dog
y/nboxRabies= y
y/nboxHeartworm= n
y/nboxFrontline= not selected

Send to Report

--report displays all animals that are dogs, have had rabies shots, have not had heartworm medicine, and may or may not have had Frontline.--

((Using MSAccess 2007))

 

[brsawvel]

If that's possible, that'd be cool...As long as by using the same form, I don't create a new record in the process. I know there's a code you can add to your thread that tells the program to undo the entry, but I can't remember what it is. It's been a while since I've messed with Access.

 

[brsawvel]

does the code send the data to a report or filter the form itself? Thanks for the info.

 

[boblarson]

does the code send the data to a report or filter the form itself? Thanks for the info.

Check out this sample where you can have a generic query and report and then call it in different ways as needed:

http://downloads.btabdevelopment.com/Samples/reports/Sample-GenericReport.zip

 

[brsawvel]

Thanks Bob, but I'm not sure that's what I was looking for. I'm actually trying to set it up so the same form that I use to input data into a table can be used to generate a report based on the parameters entered.
The types of fields on the form include text boxes, cbo boxes, and yes/no boxes.
I assume the basic thing is adding a "Filter By" button, but how do I write the code to tell the report to ignore any fields that have no information typed in them?