Form to display subset of records in datasheet mode

[here4real]

I created a form to enter the lookup data and build the SQL string to create a recordset in VBA that is a subset of the original data. Using the Form wizard I created a form that displays ALL of the records in that original table (actually a QUERY). What I want to do is open this second form but have it reference the recordset I built in VBA. Is there an easy way to do this?

Thanks.

 

[here4real]

I got it. Instead of building a recordset, I changed it to build a query. Then I set the recordset on the form to the query. Based on the lookup form, the parameters of the query change to determine the subset of the original data, but the form always references the query.