[AccessD] Combo on Continuous Form

Jürgen Welz jwelz at hotmail.com
Wed Mar 10 00:17:49 CST 2004


Acutally I meant multiple instances of the entire form.

It's been a while since I did this.  Last time I used a textbox control over 
a combo hiding everything but the dropdown arrow.  In the gotfocus event of 
the textbox I hid the textbox and dropped the combo.  In the lost focus I 
unhid the textbox.  This was a bit unnerving in that the values in all the 
rows would be identical while the combo had focus but it worked fairly well.

I recall seeing a less kludgy solution but can't remember exactly where.

I just tried moving a separate form sized as a combo to the coordinates of 
the active control but Access does not accurately report the top position of 
the control in the current row of a continuous form.

This is one of the places where an unbound grid of display controls comes 
into its own and this is the manner in which I handled this kind of thing 
more recently.  It's a lot of code to build a scrollable grid of display 
controls.

Ciao
Jürgen Welz
Edmonton, Alberta
jwelz at hotmail.com





>From: "Mark A Matte" <markamatte at hotmail.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: accessd at databaseadvisors.com
>Subject: RE: [AccessD] Combo on Continuous Form
>Date: Wed, 10 Mar 2004 04:42:13 +0000
>MIME-Version: 1.0
>X-Originating-IP: [24.167.155.76]
>X-Originating-Email: [markamatte at hotmail.com]
>X-Sender: markamatte at hotmail.com
>Received: from mc12-f22.hotmail.com ([65.54.167.158]) by 
>mc12-s11.hotmail.com with Microsoft SMTPSVC(5.0.2195.6824); Tue, 9 Mar 2004 
>20:43:05 -0800
>Received: from databaseadvisors.com ([209.135.140.44]) by 
>mc12-f22.hotmail.com with Microsoft SMTPSVC(5.0.2195.6824); Tue, 9 Mar 2004 
>20:43:05 -0800
>Received: from databaseadvisors.com (databaseadvisors.com 
>[209.135.140.44])by databaseadvisors.com (8.11.6/8.11.6) with ESMTP id 
>i2A4gBM08877;Tue, 9 Mar 2004 22:42:11 -0600
>Received: from hotmail.com (bay1-f111.bay1.hotmail.com [65.54.245.111])by 
>databaseadvisors.com (8.11.6/8.11.6) with ESMTP id i2A4g7M08825for 
><accessd at databaseadvisors.com>; Tue, 9 Mar 2004 22:42:07 -0600
>Received: from mail pickup service by hotmail.com with Microsoft 
>SMTPSVC;Tue, 9 Mar 2004 20:42:13 -0800
>Received: from 24.167.155.76 by by1fd.bay1.hotmail.msn.com with HTTP;Wed, 
>10 Mar 2004 04:42:13 GMT
>X-Message-Info: jl7Vrt/mfsrUVeJNP+9RdguElqSJX66F
>Message-ID: <BAY1-F111NVYlLdHMuk0000eea9 at hotmail.com>
>X-OriginalArrivalTime: 10 Mar 2004 04:42:13.0964 
>(UTC)FILETIME=[0EE098C0:01C4065A]
>X-BeenThere: accessd at databaseadvisors.com
>X-Mailman-Version: 2.1.4
>Precedence: list
>List-Id: Access Developers discussion and problem 
>solving<accessd.databaseadvisors.com>
>List-Help: <mailto:accessd-request at databaseadvisors.com?subject=help>
>List-Post: <mailto:accessd at databaseadvisors.com>
>List-Subscribe: 
><http://databaseadvisors.com/mailman/listinfo/accessd>,<mailto:accessd-request at databaseadvisors.com?subject=subscribe>
>List-Archive: <http://databaseadvisors.com/pipermail/accessd>
>List-Unsubscribe: 
><http://databaseadvisors.com/mailman/listinfo/accessd>,<mailto:accessd-request at databaseadvisors.com?subject=unsubscribe>
>Errors-To: accessd-bounces at databaseadvisors.com
>Return-Path: accessd-bounces at databaseadvisors.com
>
>Jürgen,
>
>If by multiple instances...you mean same combo appearing on each 
>row/record...then yes...this is what I am trying to accomplish.
>
>Thanks,
>
>Mark
>
>
>>From: "Jürgen Welz" <jwelz at hotmail.com>
>>Reply-To: Access Developers discussion and problem 
>>solving<accessd at databaseadvisors.com>
>>To: accessd at databaseadvisors.com
>>Subject: RE: [AccessD] Combo on Continuous Form
>>Date: Tue, 09 Mar 2004 21:10:58 -0700
>>
>>As long as you're not using multiple instances of your continuous form you 
>>can set the rowsource of the combo with a where clause referencing the 
>>Forms.FormName.FilterControlName.  The reason it doesn't work with 
>>multiple instances is you need the absolute form reference.  There are 
>>workarounds to the mulit instance issue but they are not convenient.
>>
>>
>>
>>Ciao
>>Jürgen Welz
>>Edmonton, Alberta
>>jwelz at hotmail.com
>>
>>
>>
>>
>>
>>>From: "Mark A Matte" <markamatte at hotmail.com>
>>>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
>>
>>_________________________________________________________________
>>Tired of spam? Get advanced junk mail protection with MSN Premium   
>>http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines
>>
>>--
>>_______________________________________________
>>AccessD mailing list
>>AccessD at databaseadvisors.com
>>http://databaseadvisors.com/mailman/listinfo/accessd
>>Website: http://www.databaseadvisors.com
>
>_________________________________________________________________
>Create a Job Alert on MSN Careers and enter for a chance to win $1000! 
>http://msn.careerbuilder.com/promo/kaday.htm?siteid=CBMSN_1K&sc_extcmp=JS_JASweep_MSNHotm2
>
>--
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Add photos to your e-mail with MSN Premium. Get 2 months FREE*  
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines




More information about the AccessD mailing list