How to refer to a column in a multiple-column combo box (1 Viewer)

sdp_tws · May 6, 2009

I found this in the tips section:

You need to create an expression that refers to the Column property of the list box or combo box control.
The syntax follows the form:

[Forms]![Form Name]![Combo Box Control Name].[Column]

Amend the Form Name and Combo Box Control Name and enter the column number n, where n will be one less than the actual column number because Access counts from zero for column one and so on.

Only I can't get it to work, I am typing

[Forms]![Staff_Training_Search]![Combo37].[Column](1)

and the error message I get is

Undefined function '[Forms]![Staff_Training_Search]![Combo37].[Column]' in expression.

I'm using Access 2003, can anyone explain what I am doing wrong?

DCrake · May 6, 2009

Depends where you are referring to it but the coloumn

does not need to be in square brackets

Example

x = Forms("FormName")("ComboBoxName").Column

David

namliam · May 6, 2009

n is Zero based though, meaning the first column is 0
The second column is 1
etc..

sdp_tws · May 6, 2009

DCrake said:
Depends where you are referring to it but the coloumn does not need to be in square brackets

Example

x = Forms("FormName")("ComboBoxName").Column

David

Thanks, that looks like vbasic? I'm referring to it in the criteria field in a query.

namliam said:
n is Zero based though, meaning the first column is 0
The second column is 1
etc..

Yes, thanks. I'm referring to the second column (column 1).

JANR · May 6, 2009

Thanks, that looks like vbasic? I'm referring to it in the criteria field in a query.

You can't refrence the column property in a query, sorry. You can only use column

in a form.

JR

sdp_tws · May 6, 2009

JANR said:
You can't refrence the column property in a query, sorry. You can only use column in a form.

JR

Ah, that explains it. But I could add a text box on the form, use that to refer to the column property, then refer the query to the text box?

Fear Naught · May 6, 2009

Why would you want to refer to a column in a combobox other than the bound column for your query?

How to refer to a column in a multiple-column combo box (1 Viewer)

sdp_tws

Registered User.

DCrake

Remembered

namliam

The Mailman - AWF VIP

sdp_tws

Registered User.

JANR

Registered User.

sdp_tws

Registered User.

Fear Naught

Kevin

Similar threads

Users who are viewing this thread