Multi-select Error-allenbrowne

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Deron - 11 Apr 2008 18:04 GMT

I used the code from http://allenbrowne.com and seem to have problem with the
line. it worked fine when the table has an auto number column but i removed
that column the table has just one NAME col also it stopped displaying the
names.
When i click the command button it displays all the data wheni select a name
it says syntax error and goes to thsi line!!

can you help

strWhere = "[NAME] IN (" & Left$(strWhere, lngLen) & ")"

Reply to this Message

Wolfgang Kais - 12 Apr 2008 11:13 GMT

Hello Deron.

> I used the code from http://allenbrowne.com and seem to have problem
> with the line. it worked fine when the table has an auto number
[quoted text clipped - 6 lines]
>
> strWhere = "[NAME] IN (" & Left$(strWhere, lngLen) & ")"

I guess that the problem is that you earlier used a number field and
now the field is of type text. I therefore suggest to use this line:

strWhere = BuildCriteria("[NAME]", dbText, "IN (" & Left$(strWhere, _
lngLen) & ")")

If it happens that the list separator should not be a comma but for
example a semicolon, you should isert a line before that rplaces all
commas by a semicolon, like this:
strWhere = Replace(strWhere, ",", ";")

Signature

Regards,
Wolfgang

Reply to this Message