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

Can't save my Office documents (after computer rebuild and reauthorization) 0
Making a macro only work on certain files 2
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
My custom number list doesn't seem to save? 1
sqlite-odbc write conflict 2
VBA - exporting serial letters to single documents 0
DMax on existing record to increment serialized # fails 1
Copy previous record into form field 0

Top