Saving changes to a form

[hogan]

I have added a field to a previously created form but I can not save the
change. I close the form and I'm asked if I want to save changes and I click
yes. The form will not close and this just repeats everytime I try to close.
Any suggestions?

Thank you.

 

[Golfinray]

First, make sure your form is editable (has the arrow and asterisk at the
bottom.) If your form is not editable it won't let you add data. If your form
is not editable, the query or table it is based on is not editable. Second,
if your form is editabel, add a command button to the form. Use the command
button wizard and select form operations/save form. Even though the form
should save without the command button, I always put it on there anyway so
the users will make sure their data is saved.

 

[John W. Vinson]

I have added a field to a previously created form but I can not save the
change. I close the form and I'm asked if I want to save changes and I click
yes. The form will not close and this just repeats everytime I try to close.
Any suggestions?

Thank you.

Try opening the form *just in design view* - i.e. don't open it with data at
all. Make the change and save it.

My guess is that you have some VBA code in the form's Close or BeforeUpdate
event which is causing the problem - do you have anything in those Event
properties? if so please post the code.

 

[hogan]

I have nothing in the event properties. I have been playing around with it
and it will not save even if when no changes made. I have to select no when
asked if I want to save it.

 

[John W. Vinson]

I have nothing in the event properties. I have been playing around with it
and it will not save even if when no changes made. I have to select no when
asked if I want to save it.

This makes NO sense. What specific steps, click by click and keystroke by
keystroke, are you taking?

 

[hogan]

John, I open the form in design view. Click "add existing fields". Select the
field I want and drag to the form. I select save and it appears to save but
when I close the form it asks again if I want to save and then repeats from
there. Let me add that the form is a subform but I'v never had issues before.
I am also running office 2007.

Thanks