Charlotte Foust
cfoust at infostatsystems.com
Fri Jun 18 12:22:14 CDT 2004
If you want drill down flexibility, then subdatasheets give you that, although they are ugly. If you want a more sophisticated look, two forms or two subforms are the answer. You could always put a continuous subform in the footer, as well, put a details button in the detail section of the parent form, and unhide the subform if the user clicks on that button. Charlotte Foust -----Original Message----- From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] Sent: Friday, June 18, 2004 6:40 AM To: Access Developers discussion and problem solving Cc: Ben Saltzer Subject: Re: [AccessD] Continuous form on a continuous form Jim: Two forms then? Linked by the OnCurrent or Click event of the first one? That seems to be where this is headed. Rocky ----- Original Message ----- From: "Jim Lawrence (AccessD)" <accessd at shaw.ca> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Thursday, June 17, 2004 10:15 PM Subject: RE: [AccessD] Continuous form on a continuous form > Hi Rocky: > > Why not handle it like a drill-down process? When an item on the continuous > form is selected a popup menu appears showing a full grid of the > related sub-items. > > HTH > Jim > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin > - Beach Access Software > Sent: Thursday, June 17, 2004 12:39 PM > To: AccessD at databaseadvisors.com > Subject: [AccessD] Continuous form on a continuous form > > > 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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com