Hi Leo,
This can be caused by a few things. In order to pinpoint the exact
cause, try modifying a record in the query recordset and take a look
at the status bar. If it reflects something like "This recordset is
not updatable" then the most common reasons for this are:
- You are utilizing Domain Aggregate functions in the query (the Total
row is turned on)
- You do not have a primary key established in your primary table.
If the status bar reflects a different message then please provide the
exact message and we'll go from there.
Additionally, if you do not know how to create a primary key or know
which table should be your primary table then you may have better luck
posting to the Access New Users newsgroup. I'm sure the experts who
hang out there will have some links to tutorials you can utilize.
--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.
~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
Word FAQ:
http://mvps.org/word
TechTrax eZine:
http://mousetrax.com/techtrax/
MVP FAQ site:
http://mvps.org/
