Storing a Query In a Record

M

Mark

Hi,

I am using Access XP.

If I store SQL text in a record how can I call the QBE grid from a text box
and save it back when the QBE grid is closed - like the Record Source
property on a form or report?

I currently do this with 2 steps. I.e. save the query as temp, then import
the SQL of temp into the active control.

Is there a way to do this in 1 process just like the Report or Form Record
Source property?

Many thanks for your help.

--

Cheers
Mark

Free Access/Office Add-Ins at:
http://mphillipson.users.btopenworld.com/
 

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