ugh, thanx for the help
guess there's more than one way
this syntax works as well
rs("firstname")=blahblah
i'm just learning sql so i tend to find and use the 'native' syntax and am
finding that it is different from vb, to vbs, to the examples ms gives in
the site comparing ado to dao
so guess sql is better because its consistent across languages???

"Aaron Bertrand - MVP" <aaron@TRASHaspfaq.com> wrote in message
news:OFOd1#IUDHA.1912@TK2MSFTNGP12.phx.gbl...
> > <!-- now add a record -->
> > rs.addnew
> > rs!firstname=request.form("firstname")
>
> Ugh. Use an INSERT statement.
>
>