Clear a combobox

		Home \| Contact Us \| FAQ \| Search & Site Map \| Link to Us
		Sign In \| Join \| Other 45 Sites in Network

Discussion Groups Forms Forms Programming Queries Modules / DAO / VBA Reports / Printing Macros Database Design Security Conversion Importing / Linking SQL Server / ADP Multiuser / Networking Replication Setup / Configuration Developer Toolkits ActiveX Controls New Users General 1 General 2

Access Directory Tools Tutorials User Groups

Related Topics

SQL Server Other DB Products MS Office More Topics ...

MS Access Forum / Modules / DAO / VBA / January 2006

Clear a combobox

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

yonina - 31 Jan 2006 09:06 GMT

hi,

I have a combo box that I want to clear. I tried combo.clear, but it doesn't
work.
How can I clear the combo through code?

Thanks.

Reply to this Message

Douglas J Steele - 31 Jan 2006 11:55 GMT

What do you mean by "clear": have nothing selected in it, or have nothing in
the dropdown section?

For the former, use Me.MyComboBox = Null

For the latter, use Me.MyComboBox.RecordSource = ""

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> hi,
>
[quoted text clipped - 3 lines]
>
> Thanks.

Reply to this Message

Sign In

Join

My Latest Posts

My Monitored Threads

My Photo Gallery

My Homepage

Start New Thread

Enable EMail Alerts

Rate this Thread

©2008 Advenet LLC Privacy Policy - Terms of Use

This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.