Quotes and Strings (Access 2002)

Topic

New Reply

Hello all:
I’m trying to set up the following criteria in VB and get a type mismatch error. [itemno], , 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! & ” ‘ ”

As always, any suggestions are appreciated. TIA.

Reply | Quote

Replies

Does the following do what you want?

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

Note that I removed some of the spaces around the single quotes, and some of the double quotes.

Reply | Quote

Hi Hans:

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

Reply | Quote

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

... AND [Description] = '201' AND ...

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.

Reply | Quote

That did it. Thanks again Hans.

Reply | Quote