Maximum subforms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have four subforms on a form (all on tabs).

I wanted to add anohter tab and another subform. All went ok until I went to
save and then it placed a previous subform on my new tab (weird). It appears
that only four subforms are allowed on a form.

My solution was to create a command button which opened a new form with the
parent data on it again and create a new child subform. Ie: Navigation
buttons to go between two forms with the same parent data.

Am I correct in saying that you can only place four subforms on a form? Any
ideas why I could not add this new subform if this is not correct because it
has happened consistently on a number of forms where I am trying to palce the
fifth subform.
 
GRIFFO said:
I have four subforms on a form (all on tabs).

I wanted to add anohter tab and another subform. All went ok until I
went to save and then it placed a previous subform on my new tab
(weird). It appears that only four subforms are allowed on a form.

My solution was to create a command button which opened a new form
with the parent data on it again and create a new child subform. Ie:
Navigation buttons to go between two forms with the same parent data.

Am I correct in saying that you can only place four subforms on a
form? Any ideas why I could not add this new subform if this is not
correct because it has happened consistently on a number of forms
where I am trying to palce the fifth subform.
Click to expand...

No, you are not correct. There's no such limit. It occurs to me that
what happened may have been the operation of the nefarious "Name
AutoCorrect" misfeature. I've seen it mess up when subforms are
involved. Click Tools -> Options..., got to the General tab, and
uncheck "Perform name AutoCorrect". You may get better performance if
you also uncheck "Track name AutoCorrect". Then see if you can add your
fifth -- or sixth, or seventh -- subform without interference.
 
Worked a treat. Thanks Dirk. The help material suggested that there was no
such limit but no matter how I did it it just suddenly (on saving) changed
the name of my subform. As suggested, unchecked the 'Perform name
AutoCorrect' (which I will do on all my databases from now on) and no
problems what so ever. Thanks again.
 
Back
Top