Set Form = Recordset

[Jen]

Hi Jake,

As far as I know, you can't set a form's recordsource to a
recordset, but what you can do is set the recordsource to
a SQL statement, like so:
------------------------------------
Dim strSQL as String
Dim rs as DAO.Recordset

strSQL = "SELECT * FROM TABLE_NAME WHERE ...."
Set rs = .....

Me.RecordSource = strSQL

Happy Coding,
Jen