Kathryn,

Open the Form in Design View and then open the Properties window. Select
the *All* tab and the very first line should say RecordSource. Click the
Build or elipse button, [...], and then in the window that opens in the
upper left hand corner, select SQL... copy and paste whatever is in that
window here.

--
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
...
Thanks Gina
How do I access the RecordSource of the form? I have checked properties,
etc.
And if that doesn't work - how do I find the SQL?!

Apologies - as I say, I am very new to this!


"Gina Whipp" wrote:

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!

.