Andy Lacey
andy at minstersystems.co.uk
Thu Apr 19 11:30:50 CDT 2007
And I guess you'd have to get the value to display by a Dlookup or something, which might be pretty slow. -- Andy Lacey http://www.minstersystems.co.uk --------- Original Message -------- From: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> To: "accessd at databaseadvisors.com" <accessd at databaseadvisors.com> Subject: Re: [AccessD] Re-query 2nd combo on subform Date: 19/04/07 15:05 The only way I've ever hear of is to display the actual value in a text box which is separate from the combo box. Sometimes this can include hiding most of the combo box most of the time. Liz Liz Doering elizabeth.j.doering at wellsfargo.com 612.667.2447 "This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation" -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey Sent: Thursday, April 19, 2007 10:46 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Re-query 2nd combo on subform I understand the issue Richard, but sad to say have never found a satisfactory solution. If I understand you right it's when the field stored by combo2 is not the one displayed, typically the bound column is the 1st column with a zero width. Is that right? So as soon as you requery the combo then most records on the subform find themselves trying to display something which is no longer in the combo's recordset as it were. I'll be watching with interest for good ideas. -- Andy Lacey http://www.minstersystems.co.uk --------- Original Message -------- From: "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: 19/04/07 14:08 Yes combo 2 has a query source that references combo 1 e.g. combo 1 - Activity Code... Combo 2 sub-Activity Code When you select Activity code you want combo 2 to list all sub-activities for that main activity code -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: 19 April 2007 13:41 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Re-query 2nd combo on subform 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ________________________________________________ Message sent using UebiMiau 2.7.2 -- 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 ________________________________________________ Message sent using UebiMiau 2.7.2