Adding controls to form and saving

[nathansav]

Hi,

I am trying to open a form in design mode and add controls, this i have done. I am doing this all in a class, and am having trouble saving the modified form.

I have tried using the following, both produce errors

DoCmd.Save acForm, "tmpQueryDes"
DoCmd.Close acForm, "tmpQueryDes", acSaveYes

Could anyone advise?

Thanks

 

[pr2-eugin]

What is the exact error you are getting?

Did you try

DoCmd.RunCommand acCmdSave

 

[nathansav]

DoCmd.Save acForm, "tmpQueryDes"
Microsoft Office Access cannot complete this operation. You must stop the code and try again.

DoCmd.Close acForm, "tmpQueryDes", acSaveYes
The Close action was canceled.

I am running the modifications from a class, i only want to save the changes i've made to the one form, tmpQueryDes, will RunCommand Save work that way?

 

[spikepl]

Unless your form is a throw-away form, you know that a form has a life-time limit of number of objects?