Quotes and Strings (Access 2002)

[BCKessinger]

Hello all:
I'm trying to set up the following criteria in VB and get a type mismatch error. [itemno], [size], and [description] are text fields in a table. ListItem, ListDesc, and Size are como boxes on a form where I make my choices.

stLinkCriteria = "[itemno] = ' " & Me![list] & " ' "

As always, any suggestions are appreciated. TIA.

[HansV]

Does the following do what you want?
<code>
stLinkCriteria = "[itemno] = '" & Me![list] & "'"
</code>
Note that I removed some of the spaces around the single quotes, and some of the double quotes.

[BCKessinger]

Hi Hans:

The error message went away, however, nothing was selected. Copy atached. Thanks again.

[HansV]

The ListDesc and ListSize list boxes both have two columns, of which the first one is hidden. This hidden column corresponds to ItemNo and is the bound column. So you end up with a condition looking like
<code>
... AND [Description] = '201' AND ...
</code>
but of course Description doesn't have 201 as value. You must change the row source, the column count and column width of the two list boxes so that there is only one column. See attached version.

[BCKessinger]

That did it. Thanks again Hans.