This is a FrontPage/Access question, and maybe there is something unique in FP's SQL syntax needs.

I have had great success updating databases from drop-down menus in forms:

UPDATE [table]
::Item::= '::New::'
WHERE ::Item:: = '::OLD::'

But, I can't retrieve in a similar fashion:

FROM [table]
WHERE ::R1:: LIKE '%::R2::%'

The problem is in the SELECT command. If I use a static column name in SELECT the script will work, but SELECT will not work with a form field.

Is this a syntax problem that cannot be resolved? Or, am I just not representing the form field correctly?

Any help would be greatly appreciated.