can't save a form with a new field in access 2007

B

Brenda

I created a new field in a form. The form will not save with the new field.
It asks if I want to save changes but won't save or close. If I say no to
save changes it closes. I created the new field in the table.
 
J

John W. Vinson

I created a new field in a form. The form will not save with the new field.
It asks if I want to save changes but won't save or close. If I say no to
save changes it closes. I created the new field in the table.
Click to expand...

It's possible that the Form's Recordsource is a query that doesn't include the
new field. Try opening the form in design view; view its Properties; click the
.... icon by the Recordsource property on the Data tab, and add the new field
to the query.
 
B

Brenda

John W. Vinson said:
It's possible that the Form's Recordsource is a query that doesn't include the
new field. Try opening the form in design view; view its Properties; click the
.... icon by the Recordsource property on the Data tab, and add the new field
to the query.
Click to expand...
Thank you for your reply. I will try this as I am not at work right now.
Thanks, again.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to Save an existing form in design mode 1
won't save after modifying form 7
Help! Can't save edited form after upgrading to 2007 1
Save Record 1
Saving changes to a form 5
DMax on existing record to increment serialized # fails 1
Can't save simple changes to a form? 2
Trying to save a SELECT statement as the Record Source for a Form 2

Top