[AccessD] Combo on Continuous Form

Ran into a similar situation this weekend.  I was building a PO system.  I
have a table that lists the parts that are 'needed'.  I then wanted to open
a continuous form, and have a combo for each 'group' of parts (it summed the
quantities requested, grouped by part number and Job number) which displays
the list of available vendors for that part.  Ran into all sorts of
problems.

What I ended up doing, was instead of using a 'natural' continuous form, I
created my own 'continuous' form.  Sure, it took an extra hour to build it,
but what I ended up with was a form much easier to control.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mark A Matte
Sent: Wednesday, March 10, 2004 3: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