Creating Query from inside the FORM

[Compuboy]

I have the SQL statement I Want to use to generate a query when in the form. Is there any way I can add a button to use this SQL statement to make a printable query??

 

[KenReay]

Hi

Yes, see DoCmd.OpenQuery in help, which will allow yo to dispaly the query as a datasheet, or consider making a report and setting the Recordsource of the report to the SQL string you have built (in the OnOPen Event of the report).

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[wemeier]

You can assign a macro to a command button that uses the OutputTo action to output the results of the query to an RTF, HTML, text or Excel file. The user could then open the output file and print it.

Cruising the Information Superhighway
_{(your mileage may vary)}