Crash on more then 4 nested subforms

[Rafal]

Hello,

In Access 2002 I created a nested 4 subforms which I would like to use to
fill 4 linked tables (research plots, sublots, vegetation layers on
subplots, species in layers and trees of particular species). I used creator
to place subforms. Access crashes when I try to add new records. It only
allows browsing existing records. I added data manually to single tables
(first created plots, then sublots etc) and evcerything works fine. I opened
my database on Access 2003 and everything worked well so I suspect that it
is a bug in Access 2002 and information about 7 leveles of nested forms is
not true. I installed Service Pack 3 but it didn't help. Have you came
across similar problems? Is there any patch for that?

Thanks in advance for your help

Rafal Buczkowski

 

[Arvin Meyer [MVP]]

Actually, I've never nested more than 2 levels deep in any application since
Access 97, but last week I ran into a similar problem after adding a second
subform (at the first level) to a form. The form performed perfectly in
Access 2002. When run on a 2003 computer it crashed instantly as soon as I
tried accessing any records, 100% of the time. I tried recompiling and even
importing everything into a new database. That did not work on either a 2002
or 2003 machine. I'm sure this is due to a binary incompatibility.

What ultimately worked was to rebuild the entire form from scratch on a 2003
machine.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Allen Browne]

Another issue to be aware of is that you need to include a text box on each
subform for each field named in LinkChildFields. The text box can be
invisible, but it can avert a bug that seems to be with the AccessField
type.