Can I have a sub-sub-form in Acess 2003

Can you have a Sub-form within a Sub-form in Acess 2003 ? Microsoft says you can nest up to 7 levels(although that may be just in 2007). When I try this it wont allow a continuous form to be embedded on another continuous form (which makes sense, but what are the mechanics of achieving sub-sub- forms in that case?)

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

The mechanics of sub-sub forms are that you have to use the single form view, with a continuous form only at the lowest level.  Since  navigation buttons are available in single form view it means records can still be scrolled at the subform level, it's just that they can't all be seen at the same time.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can use forms in Datasheet view to do this, if they will suit your needs.
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I should clarify: Using forms in Datasheet view in this manner will provide you with an interface similar to the "SubDatasheets" feature in 2003+ ... this may or may not work for you.
The 7 Worst Nightmares of a Sysadmin

Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.

fester62DeveloperAuthor Commented:
ok, thanks I thought as much.

fester62DeveloperAuthor Commented:
LSMConsulting: How do you link the Sub-datasheet ? Can that be used on a contiuous form ?


fester62DeveloperAuthor Commented:
LSMC: I dont think you can show a Sub-datasheet on a contiuous form, even if the contiuous form is in datasheet view. At least I couldnt get it to work.

Hi fester for sub datasheets to work the tables have to be linked in the relationships window and have referential integrity enforced
Leigh PurvisDatabase DeveloperCommented:
In 2003 you can have a sub-sub-sub-sub-sub-sub-form. :-)
(7 levels deep).
However - as mentioned several times now - continuous forms won't cut it.  And would be a tricky UI due to their rigid nature - hence why it's makes more sense in datasheet view).

Access 2000 introduced subdatasheets.
There's no requirement that the datasheet form sourcess be specified at the relationship level.  Created as standard linked parent and child subform will create the desired form UI result.  (Master Child link fields).

(Establishing the relationship will help Access offer such a display through the table datasheets - where the SubDatasheet property allows the desired table to be specified.  But it's just inappropriate functionality for application release of course).
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
<for sub datasheets to work the tables have to be linked in the relationships window and have referential integrity enforced>

I wasn't really referring to actual SubDatasheets, but rather using Forms in Datasheet view to mimic the look and feel of SubDatasheets. As Leigh said, the only thing you need for the Form method to work is to correctly link your forms (i.e. Master/Child links).

You can't make this work with Continuous view forms ... you must use Forms in Datasheet view.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.