New Record in subform with 2 table problem

[Guest]

My sub form has two tables in it and works fine with the following record
source query

SELECT Check_List.*, notes.* FROM Check_List LEFT JOIN notes ON
Check_List.ProjectID=notes.ProjectID;

as long as there is a existing record in my sub form table that matches my
main form table. Other wise I get the following error message:

The object doesn’t contain the automation object

If I change my sub form record source from query to just one table it will
create a new record in my sub form table like I need but the second table in
sub form does not work.

Is there a way to make this work?

 

[tina]

i'm guessing that your main form is bound to table Check_List , or to a
query or SQL statement based on table Check_List. if so, base the subform on
table notes *only* - you don't want to include Check_List in the subform's
RecordSource. in the main form Design view, click on the subform control to
select it and set both the LinkChildFields and LinkMasterFields properties
to ProjectID (if your tables are linked in the Relationships window, Access
may set the linking field properties in the subform control automatically).

hth