PC Review


Reply
Thread Tools Rate Thread

How to clear a combo/value box?

 
 
James
Guest
Posts: n/a
 
      23rd Jun 2006
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?

 
Reply With Quote
 
 
 
 
James
Guest
Posts: n/a
 
      23rd Jun 2006
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?


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:29 PM.