Hi All,

Is it possible to use form criteria in a query / view in an Access
2003 ADP with SQL Server as the backend?

ie something like:

select * from mytable where recid = forms![frm_myform]![recid]

I'm trying to do something like this as the basis for a subform but I
get a syntax error because of the existence of the "!" characters.

Any help appreciated!

Much warmth,

Murray