INSTR(), quick little syntax ?

[markjkubicki]

I have as a rowsource for a combo box a table which includes several records that I do not want as choices in the drop-down list. All of those records contain the word "Integral" in the field [options], so I thought adding a criteria:



INSTR(1,[options], "Integral")<>0

would do the trick, but every at itteration I can think of, it does not.

additionaly,
for those remaining records, some of them contain the word "Remote" which I would like to strip from the record text (it is always the 1st six letters; so, as a second criteria, I wrote something like this:

IIF(INSTR(1,[options], "Remote")<>0, MID([options],8), [options])


maybe I just don't have my thinking cap on today,
...much thanks in advance,
Mark

[weekend00]

use a query as row source of the combo box:
select xxx,xxxx from atable where options not like "*Integral*"

[pbaldy]

I don't think I'd use InStr() for either. For the first, this should work:

SELECT...
FROM...
WHERE Options Not Like "*Integral*"

For the second, I'd probably use Replace():

Replace([Options], "Remote", "")