Query ?

S

Sam

I have a select statment
that I would like to run on a button click event
and produce a view of the data.
docmd.runsql does not allow you to use the select statment
and it does not allow you to view the records.
What is the best way to achive this?

TIA
San
 
N

Nikos Yannacopoulos

Sam,

Save your query and use the command button to open it in datasheet view.
HTH,
Nikos
 
D

David Kennedy

Sam,
you can use DoCmd.OpenQuery for the select statement
DoCmd.RunSql is for Action queries ie Update,Delete etc..

David K
 
Top