Making a Dynamic Report from my Dynamic Form

[businessman]

I have a form that shows a list of all of my records in my database. I want to be able to click a button called "Report" and have that print a report that has all the records I have filtered on my form. I have a report in the format that i want it in, however, currently it prints every record and not just what is shown on my form. (The form is dynamic and I want the Report to be dynamically based on the form) HELP PLEASE!

 

[ansentry]

To me that means you are using a continious form, if so how are you filtering the data to show only the records you want?


PS Delete your duplicate post.

 

[businessman]

I wrote a bunch of code that will look at a series of checkboxes. based on the checked and not checked boxes, an SQL filter will be performed.

 

[ansentry]

If that works then why not base your report on the same query?

 

[businessman]

Because its not a real query that I'm using to filter. It's an SQL/VBA string that is inside of the code. If I write the same code in the report code, the values can't get passed.

 

[businessman]

Any other suggestions?

 

[ansentry]

What are you filtering?

CustomerName , Date Range , Date Sold etc ?

Is this form a continious form?

Bit more detail would help.