Report based on SQL

[johnLH]

I have a form for users to select various search criteria (name, date range, etc.) This form creates a SQL statement.

What's the best way to run an exisitng report based on this SQL statement?

Any thoughts appreciated.

 

[RichO]

For a similar situation, I use the SQL as an append query (appending to an empty table). Then I simply run the report based on that table and then delete all the records from the table for the next time the report is run.

 

[WayneRyan]

John,

Look in Access Help (and the Search Facility here) for QueryDef.

Base the report on a query, Run your criteria form, Generate the SQL,
Update the report's query, Then run the report.

Wayne

 

[johnLH]

Thanks guys

An OpenReport on the search criteria forms OK_click did the business:

Private Sub cmdOK_Click()

Dim strSQL As String

BuldSQLString strSQL
DoCmd.OpenReport "rptMyReport", acViewPreview, , strSQL
DoCmd.Close acForm, Me.name

End Sub