Run Time Error #2467 Object does not exist.

I've got a problem resulting in the error in above.

I'm using MSAccess ADP as a front end for a SQL 2K database

I've got a main form with about five subforms.
3 of the subforms work fine no problems.
when I added the forth I started getting this error.

I looked it up on the web several times. The best I could tell is it
had something to do with the way I loaded the main form (an on Open
script in the form modifies the recordsource). I tried the saveastext
and loadfromtext with a compact/repair between but it did not work. I
started reloading the recordsource for the subform after loading the
recordsource from the Main form, then I started referencing the
subforms with forms!MainForm!Subform instead of Me. Finally it
started working.

Then I installed the fourth form and here we go again. Nothing seems
to work.
It has something to do with the linkChild and Master fields because if
I erase them the subforms work but there is no relationship to the
main form.

Why did I ever leave mdb databases;( Just kidding.

I've seen some similar threads but they're old and the remedies in
them don't work.

(JR) wrote in message . com...
I've got a problem resulting in the error in above.

I'm using MSAccess ADP as a front end for a SQL 2K database

I've got a main form with about five subforms.
3 of the subforms work fine no problems.
when I added the forth I started getting this error.

I looked it up on the web several times. The best I could tell is it
had something to do with the way I loaded the main form (an on Open
script in the form modifies the recordsource). I tried the saveastext
and loadfromtext with a compact/repair between but it did not work. I
started reloading the recordsource for the subform after loading the
recordsource from the Main form, then I started referencing the
subforms with forms!MainForm!Subform instead of Me. Finally it
started working.

Then I installed the fourth form and here we go again. Nothing seems
to work.
It has something to do with the linkChild and Master fields because if
I erase them the subforms work but there is no relationship to the
main form.

Why did I ever leave mdb databases;( Just kidding.

I've seen some similar threads but they're old and the remedies in
them don't work.

Update. I deleted the linkChild/master fields and not it works. I'm
beginning to suspect that if the recordset for the subform is modified
in vb then the relationships must be established in vb and not in the
subform control properties.