Getting Combobox.Value in Access VBA

ms-access vba combobox ms-access-2007
hrezs picture hrezs · Oct 6, 2011 · Viewed 75.3k times · Source

I have this code:

If Me.Combobox.Value = "My Text" Then

As I want to test if "My Text" is the only value selected, however, the conditional is skipped.

I have also tried

Me.Combobox.Column(1)

and

Me.Combobox.Text

I believe there is some simple solution that I'm just overlooking.

Answer

hrezs picture hrezs · Feb 8, 2012

Me.Combobox.Column(1) decided to work as I retested the possibilities.

Related questions

How to populate a ComboBox with a Recordset using VBA

There is some literature available at expert's exchange and at teck republic about using the combobox.recordset property to populate a combobox in an Access form. These controls are usually populated with a "SELECT *" string in the 'rowsource' properties of …

Read More
Search as you type with MS Access Combobox

I would like to create a simple search-as-you-type combobox in Microsoft Access as shown in the image below. NB: the above image is from a complicated implementation of what I am trying to achieve from here My combobox is named …

Read More
Code to loop through all records in MS Access

I need a code to loop through all the records in a table so I can extract some data. In addition to this, is it also possible to loop through filtered records and, again, extract data? Thanks!

Read More