SQL & VBA

[ChampionDuy]

I have a button that runs a SQl statement. How do I get the output from the SQL statement into a text box OR how could I get the output to a report. Either one will work.

 

[Travis]

If the SQL is a select statement then on the Open Event of a Report change its RecordSource Property to the SQL Statement.

 

[ChampionDuy]

Thanks Worked Great!!!