Recordset not updateable message displayed when form opens

[Larry Kahm]

Running Access 2003 (SP3), I have a form based on a query. When the form
opens, the status bar displays the message, "This recordset is not
updateable."

Yet, when the query is open in datasheet view, I can manually enter new
records (the first column displays the star and the Project ID column has
(AutoNumber) shown).

How can I track down what the form could be doing that would cause this
message to appear?

Thanks!

Larry

/ps/

SQL code from the query:

SELECT tblProjects.*, tblMarketingData.MarketingProjectID,
tblCompanies.CompanyName, tblMktProjectTypes.MarketingProjectType,
tblPrjOrigArchitects.OriginalArchitect, [PNLocation] &
IIf(IsNull([PNLocation]),[PNObject],", "+[PNObject]) & (", "+[PNTask]) AS
MarketingProjectName
FROM tblMktProjectTypes RIGHT JOIN (tblPrjOrigArchitects RIGHT JOIN
(tblMarketingData RIGHT JOIN (tblCompanies RIGHT JOIN tblProjects ON
tblCompanies.CompanyID = tblProjects.CompanyID) ON
tblMarketingData.MarketingDataID = tblProjects.MarketingDataID) ON
tblPrjOrigArchitects.PrjOrigArchitectID = tblProjects.OriginalArchitectID)
ON tblMktProjectTypes.MktProjectTypeID = tblProjects.MktProjectTypeID;

 

[Jerry Whittle]

The query based on more than one table. Here's something to check:
http://support.microsoft.com/?kbid=328828

Instead of a query for two tables, often it's best to have a form based on
the parent table and on this form place a subform based on the child table.
Just make sure that you have relationships set up properly in the
Relationship Window.

Also by 'star' I'm assuming that you might have table-level lookup tables.
These can cause all sorts of problems. Here's a few of them:
Http://www.mvps.org/access/lookupfields.htm

Further check out the second commandment here:

http://www.mvps.org/access/tencommandments.htm