On click running query

  • Thread starter Thread starter Alex
  • Start date Start date
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
 
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.
 
Back
Top