It does not like this piece of code

[eme126]

For some reason it does not like the percent sign:

oSQL = "SELECT*"
FROM TableInfo
WHERE Caption Like "' & strTarget & "%'"

oResults = oSQL.Execute

Any ideas...

 

[Matt Greatorex]

Just a few observations.

There are no spaces between SELECT and *.
The second and third lines don't appear to be connected to the first.
You can probably rewrite the 'Like...%' part, to use the INSTR() function.