[AccessD] Combo on Continuous Form

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
>






More information about the AccessD mailing list