Limit to number of forms??

[Sandra]

I have a tabbed form for a master table of Donors.
Page 1 has the master Donor form
Page 2 has a subform for Relations linked to Donors.
Page 3 has a subform for Donations linked to Relations,
and embedded in this subform are 2 subforms linked to
Donations for adding extra information that is not
required for every donation record.

Everything is working fine except for the subforms on the
subform Donations. One subform works OK and maintains a
link to the Donations record. The last subform I placed
does not. It fills out OK as a new record, but does not
resync when you enter the parent donation record again.
All the underlying tables are linked, and I have
referential integrity among all the tables. Master and
child properties are linked.

Technically, these subforms are 3 levels deep, is there a
problem with this, or have I just goofed up somewhere?

Thanks,

Sandra

 

[John Vinson]

Technically, these subforms are 3 levels deep, is there a
problem with this, or have I just goofed up somewhere?

What version of Access? In 2000 and above you can nest *seven* deep
(not that I'd ever want to, that would be a user nightmare).

I'd guess that you've made some subtle error - check each subform's
Master/Child Link Field properties carefully, and open each form
independently if possible to be sure that its recordsource is
returning the correct data. Or, the entire form might be corrupted -
try creating a new database and Importing everything.

 

[Sandra]

Well DUH!!!
After fiddling with this thing for an hour and checking
all of my code, I finally went to form properties and I
had the DataEntry checked yes. That's what happens when
you work too late LOL!