Kathryn,

It's actually the RecordSource of your form that is not allowing you to add
new records. Have you reviewed that? The form only displays the
RecordSource. Fix the query and you fix the issue. If the you think the
query should be allowing new then post the SQL here for us to take a look.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Kathryn" wrote in message
...
Hi

I am still pretty new to Access and had a form that worked fine until Friday
when it disappeared in Form View. Over the weekend it seemed to resolve
itself and reappeared - but... I cannot now add a new record.

I am using Access 2007. All the icons on the Records section of the Home tab
are greyed out apart from Refresh All. I had a go at creating an Add New
Record button - just to see what happened. When I click this, I get the
error
message " You cannot go to the specified record".

I have gone to Design View and looked at the various properties but nothing
seems to suggest that I can't add/ edit anything.

Any ideas gratefully received!