'new record' grayed out in query

[Mary]

Hello friends,
I recently added a calcuation field to a query (in Access 2007 in a file
saved to be compatible to Access 2003), and it even works. But now, the 'new
record' field is greyed out in both the query and, of course, the attached
form.
But I can create a new field in the table.
Help?

The calculation field I added, in case it matters, is an Expression, titled
'FigureTax: ([PricePaid]*0.0876)'

thanks so much -
Mary

 

[Duane Hookom]

Please provide the SQL view of the query.

 

[Roger Carlson]

When the "new record" button is greyed out, that is usually an indication
that the dataset (ie query) is not updateable. There may be a number of
reasons for that. I've got a blog post which explains many of them:
http://rogersaccessblog.blogspot.com/2009/11/this-recordset-is-not-updateable-why.html.


--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Jerry Whittle]

Something like a calculated field could cause a query to be unupdateable.
There are many other things. See the link below.

http://support.microsoft.com/?kbid=328828