[AccessD] Re-query 2nd combo on subform

Is it because it is on a continuous form?


>From: "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com>
>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] Re-query 2nd  combo on subform
>Date: Thu, 19 Apr 2007 05:40:43 -0700
>
>In the After Update event of Combo1 are you requerying Combo2?  What's the
>row source for Combo2?  Does it include the value of Combo1?
>
>Rocky
>
>
>
>
>
>
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Griffiths,
>Richard
>Sent: Thursday, April 19, 2007 3:50 AM
>To: AccessD at databaseadvisors.com
>Subject: [AccessD] Re-query 2nd combo on subform
>
>Hi
>
>Access 97
>
>It's been a long time since I've posted here - still take a regular look,
>even though I concentrate on .net these days.
>A combination of time without Access and lack of time to play around
>myself..... but I have someone asking my advice.
>
>Scenario.....timesheet screen...
>
>header record with continuous subform details.
>Two combo's on the subform....the second of which needs to be re-queried
>based on the value in combo 1.
>This is actioned on the after-update event of combo1.
>
>The undesired result is that on previous records in the subform combo 2 is
>cleared out when combo 1 is re-queried (if the list id different say to the
>current record).
>
>I'm sure I've been here before......but can't get the solution...so all you
>active MS Accessers..... any clues??
>
>Thanks in advance
>
>
>Richard Griffiths
>0161 253 5169
>Software Developer
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>--
>No virus found in this incoming message.
>Checked by AVG Free Edition.
>Version: 7.5.446 / Virus Database: 269.5.2/766 - Release Date: 4/18/2007
>7:39 AM
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Interest Rates NEAR 39yr LOWS!  $430,000 Mortgage for $1,299/mo - Calculate 
new payment 
http://www.lowermybills.com/lre/index.jsp?sourceid=lmb-9632-19132&moid=14888