CreateControl And Not Saving The Final Form

[rr191]

I have an Access 97 form that I add label controls to based on data from a query. I open the base form in design mode, use CreateControl() to add the labels and then display the resulting form. When the form is closed, I get a prompt to save changes to the form.

How can I close the form and not save changes and not get a prompt from Access 97?

 

[KenReay]

Hi

set the save parameter to false:

Syntax

DoCmd.Close [objecttype, objectname], [save]

so DoCmd.Close acForm,"FormName",acSaveNo

Regards

Ken Reay
Freelance Developer
kenneth.reay@talk21.com

 

[rr191]

Thanks for the help. I've added a button to the form and use it to close without saving the design changes. The only problem is that it seems to work sometimes and not other -- I get an error that the expression cannot be evaluated. I guess I must have a problem in my code somewhere.

-- Rob