Query ?

  • Thread starter Thread starter Sam
  • Start date Start date
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
 
Sam,

Save your query and use the command button to open it in datasheet view.
HTH,
Nikos
 
Sam,
you can use DoCmd.OpenQuery for the select statement
DoCmd.RunSql is for Action queries ie Update,Delete etc..

David K
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DELETE FROM a table WHERE... 1
Too many IIF statements 3
docmd.runsql help 2
iif and statement 2
Data Mismatch in Excel 2010 4
DatePart in Query design mode??? 2
Query Criteria: evaluating criteria as a group 3
Compair tables 1

Back
Top