[AccessD] How do I clear a combobox? (emailcontainsafairamountof code)

Charlotte Foust cfoust at infostatsystems.com
Fri Jun 6 19:13:11 CDT 2008


If the combobox text is set to Show All Records and the combo isn't
limit to list, then you'll see this effect.  You can set the index of
the combobox to -1 (which is none selected) and see if that works.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bob Gajewski
Sent: Friday, June 06, 2008 4:53 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] How do I clear a combobox?
(emailcontainsafairamountof code)

Correct - it does not work, but I am sure that the code is executing
because I put MsgBox's between every line of code in that module and
they all displayed  :(

What happens is that the underlying row source is set to the new query,
as the code intends, but the "(Show All Records)" is still displayed in
the combobox.

Bob G. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Friday, June 06, 2008 08:59 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] How do I clear a combobox? (email
containsafairamountof code)



> Susan
>
> #2 - no selected item.
>
=======And you said that

me.combobox.value = ""

doesn't work? What does happen -- are you sure the code's actually
executing that statement? Do you get an error?

Susan H. 

--
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




More information about the AccessD mailing list