Jim DeMarco
Jdemarco at hudsonhealthplan.org
Thu Mar 11 08:08:50 CST 2004
Right but he's using a continuous form here with each row requiring a differing set of filter choices. Let's use an example of the first two rows being two different items as follows and using a combo box located on the continous form: Record 1 filters by: ItemA or ItemB Record 2 filters by: ItemC or ItemD I'm in row 1 and I select ItemA from the drop down (that is on the continuous form). All rows will show I've selected ItemA even those where ItemA is not applicable (due to the nature of continous forms unless I'm way off base here). I think this would confuse users. It's why I suggested putting the filter criteria in the header where it will only appear once and is always visible as you scroll the form and only shows the options available for the currently selected record. Jim DeMarco -----Original Message----- From: Reuben Cummings [mailto:reuben at gfconsultants.com] Sent: Thursday, March 11, 2004 8:43 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Combo on Continuous Form 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 > -- _______________________________________________ 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". ***********************************************************************************