I found this in the tips section:
Only I can't get it to work, I am typing
I'm using Access 2003, can anyone explain what I am doing wrong?
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
and the error message I get is[Forms]![Staff_Training_Search]![Combo37].[Column](1)
Undefined function '[Forms]![Staff_Training_Search]![Combo37].[Column]' in expression.
I'm using Access 2003, can anyone explain what I am doing wrong?