proper bracketing to get combo column into a query

  • Thread starter Thread starter asc4john
  • Start date Start date
A

asc4john

I am trying to get the text value from a combobox into a query where
clause like so

Like "*" & Chr(34) & [Forms]![frmItemTypes]![cboItemDivision].
[Column(1)] & Chr(34)
but nothing works. This works but only for numbers [Forms]!
[frmItemTypes]![cboItemDivision].
How do I bracket for text from columns in the combo box?
 
I am trying to get the text value from a combobox into a query where
clause like so

Like "*" & Chr(34) & [Forms]![frmItemTypes]![cboItemDivision].
[Column(1)] & Chr(34)
but nothing works. This works but only for numbers [Forms]!
[frmItemTypes]![cboItemDivision].
How do I bracket for text from columns in the combo box?
Click to expand...

[FieldName] LIKE '*" & Forms!MyForm!cboItemDivision & "*'"

Open is single quote then asterisk. Close is the opposite.
 
I am trying to get the text value from a combobox into a query where
clause like so
Click to expand...
Like "*" & Chr(34) & [Forms]![frmItemTypes]![cboItemDivision].
[Column(1)] & Chr(34)
but nothing works. This works but only for numbers [Forms]!
[frmItemTypes]![cboItemDivision].
How do I bracket for text from columns in the combo box?
Click to expand...

[FieldName] LIKE '*" & Forms!MyForm!cboItemDivision & "*'"

Open is single quote then asterisk. Close is the opposite.
Click to expand...


[Forms]![frmItemTypes]![cboItemDivision] seems to refernce column(0)
which is a number, I need column(1) which is text
So ItemDivision.name LIKE "*" & [Forms]![frmItemTypes]!
[cboItemDivision].column(1) is what I need
But putting [Forms]![frmItemTypes]![cboItemDivision].column(1) in
without [] gives an "unrecognized function" error and with [] gives a
request to Enter Parameter Value.
 
Unfortunately, you can't use the Column property in a query.

One option you could try would be to create a function that returns the
value of the 2nd column:

Function ReturnSecondColumn(MyCombo As Combobox) As String

ReturnSecondColumn = MyCombo.Column(1)

End Function

and then use that function in your query:

Like Chr$(34) & "*" &
ReturnSecondColumn([Forms]![frmItemTypes]![cboItemDivision]) & Chr$(34)
 
Back
Top