How to clear a combo/value box?

's Computer Specifications

I've got a value box (type of combo box) that is populated based on a
query, upon form exit i want to clear the value box so new values can
be input the next time it is opened. Currently new values are just
added every time and nothing is removed from the value box. Any ideas?

's Computer Specifications

I figured it out....

you use the .rowsource property and set it to Empty

ie.

cboValueBox.rowsource = Empty

wow that was simple.

cboBox.RowSource
James wrote:
> I've got a value box (type of combo box) that is populated based on a
> query, upon form exit i want to clear the value box so new values can
> be input the next time it is opened. Currently new values are just
> added every time and nothing is removed from the value box. Any ideas?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
clear a combo box	BobC	Microsoft Access Forms	1	3rd Jun 2008 08:28 AM
How to clear a combo box .net 2.0	=?Utf-8?B?TGFtYm9yZ2hpbmk=?=	Microsoft Dot NET Framework Forms	3	6th Oct 2006 02:32 PM
Clear Combo box	DeVille	Microsoft Access Form Coding	2	19th Mar 2004 03:12 AM
combo box won't clear	dpdeleon	Microsoft Access	1	22nd Sep 2003 10:30 PM
clear combo box	Julie T	Microsoft Access Form Coding	0	17th Aug 2003 11:15 PM