[AccessD] Open a combobox on entering it

Arthur,
I too am getting to the stage in life where change is more trouble than it's worth.
However, I have had several cases where if I renamed the control by appending the name the errors and problems have disappeared.  Most significant in using the domain functions.   

Jim 
jhewson at karta.com
 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Monday, July 02, 2007 5:05 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Open a combobox on entering it

I know that lots of people here despise that style, but I've been naming
controls the same as their data source for about 15 years and this dog is
too old for new tricks. In a few months I'll be 60. Of course, I'm too poor
to choose retirement at 60. I'm learning Java currently, but it's not really
a new trick :-)

There must be something else going on here. I just whipped up a tester in
Access 2000 and the dropdown attribute is available in the OnEnter event. I
repeated it in 2003 and it worked. I repeated it in 2003 against a SQL
database and it worked. So there must be something odd about the database I
was working on when the problem arose. My testers created one combo using a
value list and another using a table.

So I have no idea why I wasn't able to get it before.


Arthur


On 7/2/07, Steve Schapel <miscellany at mvps.org> wrote:
>
> Hmmm.  Well, in that case, probably not.  If the control and the field
> are both named the same as each other, then you can't get it wrong! :-)
>
> Regards
> Steve
>
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com