Bob Gajewski
rbgajewski at adelphia.net
Fri Jun 6 18:53:25 CDT 2008
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