>OK, thanks. This 'seems' to be a little inconsistent with how you were constructing the WHERE clause back in Message #1295677, but maybe I'm missing something.
>
>So I'm just trying to get a handle on what specifically is in the SQL text that you're passing to sqlexec.

That depends on the actual contents of the 'cWhere' variable :). That could include the parameters (just a question mark in front of the variable). IOW, I did not specify whether parameters or merge text was used.

so the whereclause could be something like:

City = ?THISFORM.City AND Address LIKE ?m.Address

As long as the variable is in scope (Public or private), this would work well

Walter,