On click running query

A

Alex

Hi need some more help please!

On click of a button I store a RecordId into a variable. I then need to run
a query which spans multiple tables, where RecordId = the variable. Do I -
DoCMd.OpenQuery and in which case how do I place the variable, or do I
RUNSQL?

Thanks

Alex
 
K

Ken Snell

Completely depends on what you'll do with the query after it runs (do you
want the values for use in the code? is a form or report based on the query?
is the query updating some table?).

You need to give us more info, please.
 

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

Top