HOW TO CREATE A FORM TO GENERATE REPORT WITH OPTIONS OF USERS

[hoprogramevaluator]

i AM WORKING ON CREATING A FORM WHICH IS LINKED TO A QUERY. THE QUERY IS TO GENERATE A REPORT BASED ON SELECTED TEAM NAME OR DATE. BOTH THE SELECTION OF THE TEAM NAME AND DATE CAN BE ENTERED BY THE THE USER AT THE POINT WHEN HE ACCESS THE FORM AND KEY INTO IT BY HIMSELF (THAT MEANS HE CAN CHOOSE WHICH TEAM HE WANTS THE REPORT IS BASED ON AND DATE. THE TEAM NAME IS DEFINED AND SAVED IN THE TABLES.

 

[petrosky]

Hi,

Please don't SHOUT your question...if that is what it is.

In the query window you are going to need to refer back to the values on the form as the conditions for your query.

eg. [Forms]![YourFormName]![YourControl]

Similar logic for dates

HTH.

Peter.

Remember- It's nice to be important,
but it's important to be nice

 

[MajP]

Like Peter said you can put references to control values as criteria for your query, or you can use a "where" clause in your docmd.open report. Ex:

DoCmd.OpenReport "Sales Report", acPreview,, "companyName = '" & me.companyName & "'"

I prefer the latter because it provides a more flexibility and error checking. Especially if you have multiple criteria. With only Team and Date you may find it as easy to go with the original suggestion.