Hello all.

I hope someone can help.
i'm running an hierarchical db wherein i have created a series of 3-tired forms:
main form with 1 PK.
subform with the above PK and a new PK (section id)
sub-subform with the above 2 PK's and one (or more) new ones.

everything went smooth - i could update and add data, every chunk of data went to the correct place.
suddenly i could no more. some tables still work though. other tables, which have same columns as keys, are not displayed when using forms wizard. if i complete the operation i get SUBSCRIPT OUT OF RANGE error message.

does anyone have a clue?
i'm using access 2000, and compacted and repaired the db, and yes, i also tried to import all objects to a new db.
(i also searched this excellent archive but found nothing).

thank you for any advice,

Ubiq.

kind of solved it by not using the form wizard.

still i wonder, why is the form wizard not able to create nested sub forms on some occasions when all relations are layed out correctly.


Ubiq.