I
iori
i have a subform on a form with Source Object="Query.myquery", my form is
generating a sql string dynamically and assigning this sql string to the
RecordSource property which works fine. But now if the user changes the width
of the columns in the subform and close the form , a prompt is thrown asking
if the "myquery" needs to be saved. I dont want to save the settings of
"myquery" but at the same time avoid this modal dialog. If i use
DoCmd.SetWarnings=False , i dont see the warning anymore BUT the query gets
saved.
I am using "myquery" to just display column names in the subform when the
forms loads and also without it i cant directly use RecordSource property in
my code.
any suggestions?
generating a sql string dynamically and assigning this sql string to the
RecordSource property which works fine. But now if the user changes the width
of the columns in the subform and close the form , a prompt is thrown asking
if the "myquery" needs to be saved. I dont want to save the settings of
"myquery" but at the same time avoid this modal dialog. If i use
DoCmd.SetWarnings=False , i dont see the warning anymore BUT the query gets
saved.
I am using "myquery" to just display column names in the subform when the
forms loads and also without it i cant directly use RecordSource property in
my code.
any suggestions?