Reuben Cummings
reuben at gfconsultants.com
Thu Mar 11 07:43:12 CST 2004
Unless I'm missing something, this is something I do quite often. I base the combo on parameterized SQL (just like a parameter query but I paste the sql into the combo box) and requery the query on Got_Focus. You can also use On_Current - I have done it this way when I want to disable the combo in some records. Reuben Cummings GFC, LLC phone: 812.523.1017 email: reuben at gfconsultants.com > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim DeMarco > Sent: Thursday, March 11, 2004 8:08 AM > To: Access Developers discussion and problem solving > Subject: RE: [AccessD] Combo on Continuous Form > > > Since it's a continuous form the drop down will repopulate for > every record anyway (even though you won't physically see that) > so the header may still make sense. Keep a hidden text box in > the header as well for the unique record identifier then you can > refill the header combo with the correct list values based on the > text box value. Make sense? > > Jim DeMarco > > -----Original Message----- > From: Mark A Matte [mailto:markamatte at hotmail.com] > Sent: Wednesday, March 10, 2004 4:50 PM > To: accessd at databaseadvisors.com > Subject: RE: [AccessD] Combo on Continuous Form > > > > Because the form I'm building will be the same form for multiple > products...but each product will have different attributes...and > different values available depending on the product and the > attribute. So the > dropdown on each row will have different values...depending on what > attribute is on that row. > > Thanks, > > Mark > > >From: "Jim DeMarco" <Jdemarco at hudsonhealthplan.org> > >Reply-To: Access Developers discussion and problem > >solving<accessd at databaseadvisors.com> > >To: "Access Developers discussion and problem solving" > ><accessd at databaseadvisors.com> > >Subject: RE: [AccessD] Combo on Continuous Form > >Date: Wed, 10 Mar 2004 10:28:35 -0500 > > > >Mark, > > > >Why not put it in the form Header instead? > > > >Jim DeMarco > > > >-----Original Message----- > >From: Mark A Matte [mailto:markamatte at hotmail.com] > >Sent: Tuesday, March 09, 2004 9:58 PM > >To: accessd at databaseadvisors.com > >Subject: [AccessD] Combo on Continuous Form > > > > > >Hello, > > > >In A2k I want a combo box on a each row of the continuous form > that filters > >by the current record on that continuous form. Suggestions anyone? > > > >Thanks, > > > >Mark > > > >_________________________________________________________________ > >Get business advice and resources to improve your work life, > from bCentral. > >http://special.msn.com/bcentral/loudclear.armx > > > >-- > >_______________________________________________ > >AccessD mailing list > >AccessD at databaseadvisors.com > >http://databaseadvisors.com/mailman/listinfo/accessd > >Website: http://www.databaseadvisors.com > > > > > > > > > > > > > >***************************************************************** > ****************** > >"This electronic message is intended to be for the use only of > the named >recipient, and may contain information from Hudson > Health Plan (HHP) that >is confidential or privileged. If you > are not the intended recipient, you >are hereby notified that any > disclosure, copying, distribution or use of >the contents of this > message is strictly prohibited. If you have received >this > message in error or are not the named recipient, please notify us > >immediately, either by contacting the sender at the electronic > mail address > >noted above or calling HHP at (914) 631-1611. If you are not the > intended >recipient, please do not forward this email to anyone, > and delete and > >destroy all copies of this message. Thank You". > >***************************************************************** > ****************** > > > >-- > >_______________________________________________ > >AccessD mailing list > >AccessD at databaseadvisors.com > >http://databaseadvisors.com/mailman/listinfo/accessd > >Website: http://www.databaseadvisors.com > > _________________________________________________________________ > FREE pop-up blocking with the new MSN Toolbar - get it now! > http://clk.atdmt.com/AVE/go/onm00200415ave/direct/01/ > > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > > > > > > ****************************************************************** > ***************** > "This electronic message is intended to be for the use only of > the named recipient, and may contain information from Hudson > Health Plan (HHP) that is confidential or privileged. If you are > not the intended recipient, you are hereby notified that any > disclosure, copying, distribution or use of the contents of this > message is strictly prohibited. If you have received this > message in error or are not the named recipient, please notify us > immediately, either by contacting the sender at the electronic > mail address noted above or calling HHP at (914) 631-1611. If you > are not the intended recipient, please do not forward this email > to anyone, and delete and destroy all copies of this message. Thank You". > ****************************************************************** > ***************** > > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >