[AccessD] Combo Box On Open Problem

Borge:

I ended up putting the code in the Current event.  Which worked.  Who knew?

Any downside to that over the Timer approach.

This is an inbound for that just allows the user to pick a person from a
combo box which is then passed to a bound form that displays all the info
about that person.


Rocky


 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of pcs at azizaz.com
Sent: Monday, September 17, 2007 8:00 PM
To: Access Developers discussion and problemsolving
Subject: Re: [AccessD] Combo Box On Open Problem

Rocky,
I would try and put the code on the Timer event of the Form to be sure that
it only runs after the Form has opened .... 
after you have run the code set the Timer so it doesn't run again ...
Regards
Borge

---- Original message ----
>Date: Mon, 17 Sep 2007 16:10:02 -0700
>From: "Rocky Smolin at Beach Access Software" 
<rockysmolin at bchacc.com>  
>Subject: [AccessD] Combo Box On Open Problem
>To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
>
>Dear List:
> 
>When a form opens I want to set focus to a combo box on 
that form and drop
>it down.  But the combo box list does not appear below the 
combo box as if
>you had clicked on the combo box after the form was open.
> 
>It appears offset to the left and below the combo box.  I 
think it's because
>the combo box is dropping down before the form is 
completely open even
>though cboGoTo.DropDown is the last line in the Open event.
> 
>Is there some way I can fix this so that the list will be 
properly
>positioned beneath the combo box when the form opens?
> 
>MTIA
> 
>Rocky
> 
> 
>
>
>
> 	
>	
>
>-- 
>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

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.487 / Virus Database: 269.13.22/1013 - Release Date: 9/17/2007
1:29 PM