Design Change at Run Time

  • Thread starter Thread starter k0zaw
  • Start date Start date
K

k0zaw

Hi,

I have a form which has two sub forms (not nested).

At runtime, I changed the formatconditions of some controls and source
objects of those subforms. Nothing problem, except at run time I was
being asked to save the design changes (for all 3 forms), sometimes.
Yes, it prompt in sometimes, not always prompt. So, I'm wondering how
do I discard the design changes in form close.

Thanks in advance
 
A command button with:

DoCmd.Close acForm, "frmWhatever", acSaveNo

Will close the form without saving or prompting.
 
On Mon, 19 Jan 2009 19:14:39 -0800 (PST), k0zaw <[email protected]>
wrote:

Look up DoCmd.Close in the help file. It has a couple of optional
parameters to help with this.

-Tom.
Microsoft Access MVP
 
A command button with:

DoCmd.Close acForm, "frmWhatever", acSaveNo

Will close the form without saving or prompting.
Click to expand...

Thanks Arvin, Tom

I'm closing that form with acSaveNo parameter.

But it is asking me for one of subform. That subform is for editing
the child records. Another form is for in viewing the child records in
continuous form.

Is there any code to insert in onclose event of subform to discard the
design change at runtime? Or to supress these design changes?

Thanks
 
The acSaveNo value should stop any prompts.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


A command button with:

DoCmd.Close acForm, "frmWhatever", acSaveNo

Will close the form without saving or prompting.
Click to expand...

Thanks Arvin, Tom

I'm closing that form with acSaveNo parameter.

But it is asking me for one of subform. That subform is for editing
the child records. Another form is for in viewing the child records in
continuous form.

Is there any code to insert in onclose event of subform to discard the
design change at runtime? Or to supress these design changes?

Thanks
 
Back
Top