David,

I know how to work with recordsets and thinking about it, I don't see any
utility in populating a form from a variable unless it is coming from
another database.

God Bless,

Mark


"David W. Fenton" wrote in message
36.94...
"Mark A. Sam" wrote in
:

A readonly recordset doesn't interest me. You
said you can do this with DAO recordsets? That is what I'd be
interested in, but only if the recordsets underlying table is
updateable with the form.

You don't need to muck around with the .Recordset property of the
form at all -- all you need to do is set the form's Recordsource to
a valid SQL string, which can include a connect string to allow you
to change the back end you're drawing the data from.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/