Storing a Query in a Record

  • Thread starter Thread starter Mark
  • Start date Start date
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?

Many thanks for your help.
 
You can read and write the SQL string of a query using

queryname.SQL

Also look in help under CreateQueryDef

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Back
Top