'new record' grayed out in query

  • Thread starter Thread starter Mary
  • Start date Start date
M

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
 
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
 
Back
Top