Design Change at Run Time

[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

 

[Arvin Meyer [MVP]]

A command button with:

DoCmd.Close acForm, "frmWhatever", acSaveNo

Will close the form without saving or prompting.

 

[Tom van Stiphout]

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

 

[k0zaw]

A command button with:

DoCmd.Close acForm, "frmWhatever", acSaveNo

Will close the form without saving or prompting.

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

 

[Arvin Meyer [MVP]]

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.

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