Form data persistence

[jmoby]

I am trying to store the recordsource sql of the form somewhere on the form. Is this possible. I want to do like what the Form.tag property is for, but instead to have the .tag stored forever, or until changed. Must I create a table to store the recordset sql, or is there another way?

 

[PHV]

What is the actual value of your form's RecordSource property ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[vladk]

jmoby,

You could store your recodset in EXCEL. You cannot store it on the form in a straight manner. Or you could store it in the text file, either txt or csv...

You could apply approach that involves property bags...

All depends on your needs and the actual values like PHV correctly mentioned.

vladk