Unable to add new records to a filtered subform based on qeury.

[hydroparadise via AccessMonster.com]

Working with Access 2003/2007 FE and SQL 2005 Server BE, although this
problem also applies to just Access as well. Here is the problem. I have
discovered that one of the great benifits of using a form displayed as a
datasheet vs just opening just the table, is that you gain a great amount of
control with what happens to the data in individual fields the way of VBA
coding. If you add a subform to a form and have it displayed as a datasheet,
that subform becomes the subdatasheet to the maid form's datasheet and still
keep all the events and controls of the subform. Here is where it gets
interesting. If the subform is based off of a dynaset query pulling from
more than one table (with no GROUP BY's), then I am unable to add any new
records to the subform (which is ultimately filtered by master/child link)
where otherwise looks possible. I get the following error:

"Microsoft Office Access can't find the object 'SELECT ((0)) AS Column1, ((0)
) AS Column2'."

The error displays exactly as that with no error codes. I don't have any
fields or aliases with name of Column1 or Column2 either. The subform has
some calculated values thats essential for the user to see, and also needs
the add new records. My question is have I hit a limit on Access/SQL, or am
I dealing with a design issue? Been beating my head on this one for a couple
weeks now, so any insight would be appreciated

 

[hydroparadise via AccessMonster.com]

that subform becomes the subdatasheet to the maid form's datasheet and still

sp> maid form = main form

 

[hydroparadise via AccessMonster.com]

To answer my own question, Access does not let you add or delete records to a
subdata sheet when its parent is filtered wether it be a table, query, or
form. It will let you modify a record tho.