Making a Dynamic Report from my Dynamic Form

businessman

Registered User.
Local time
Yesterday, 17:37
Joined
Jun 19, 2006
Messages
79
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!
 
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.
 
Last edited:
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.
 
If that works then why not base your report on the same query?
 
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.
 
What are you filtering?

CustomerName , Date Range , Date Sold etc ?

Is this form a continious form?

Bit more detail would help.
 

Users who are viewing this thread

Back
Top Bottom