[AccessD] Continuous form on a continuous form

Ken Ismert KIsmert at TexasSystems.com
Fri Jun 18 10:42:03 CDT 2004


Rocky,

Sure you can do it - it's called SubDatasheets - introduced in A2K.

Both the parent and sub forms must have their Default View set to Datasheet.
On the SubForm control, you link Child and Master fields just like any
other. The parent datasheet can be a subform as well. You can nest
subdatasheets at up to 8 deep.

What you get is a tree-like hierarchy where you can expand the subdata by
clicking on the + next to the parent record.

As long as you are willing to live with the Datasheet view, this solution
fits the bill.

-Ken

-----Original Message-----
From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com]
Sent: Thursday, June 17, 2004 6:46 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Continuous form on a continuous form


So if I don't really like this client then this is the design I'm looking
for?

Rocky

----- Original Message -----
From: "Christopher Hawkins" <clh at christopherhawkins.com>
To: <accessd at databaseadvisors.com>
Sent: Thursday, June 17, 2004 2:57 PM
Subject: RE: [AccessD] Continuous form on a continuous form


> Placing a continuous form on a continuous form will open up an
> interdimensional vortex that will suck you, your app, and your users
> into it, never to be seen again.
>
> A similar effect happens in your clothes dryer, which is why your
> socks are always disappearing.  ;)
>
> -C-
>
> ---- Original Message ----
> From: bchacc at san.rr.com
> To: AccessD at databaseadvisors.com,
> Subject: RE: [AccessD] Continuous form on a continuous form
> Date: Thu, 17 Jun 2004 12:39:22 -0700
>
> >Dear List:
> >
> >I have been chastised by Access that I can't put a continuous form
> >on a continuous form.  OK.  Is there some way around this
> >restriction?
> >
> >For example, you want to show purchase order header information
> >followed by lines of the purchase order detail.  But you want to be
> >able to scroll up and down showing the header followed by the detail
> >for all the POs in your system.
> >
> >Any clever tricks to do this or even simulate it?
> >
> >MTIA
> >
> >Rocky Smolin
> >Beach Access Software
> >http://www.e-z-mrp.com
> >
> >
> >--
> >_______________________________________________
> >AccessD mailing list
> >AccessD at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/accessd
> >Website: http://www.databaseadvisors.com
> >
>
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com






More information about the AccessD mailing list