i'm using the "data environment" thingy to create my report, on an access97 database. in the properties (in data environment), i type in the SQL statement; thus this causes the report produced will be fixed.
i'm having problems with getting an SQL statement processed in a form and put into the data environment, overwriting the previous SQL statement (in the properties - general tab), so that the user can enter a report parameter, and a more dynamic report will be created.
what i've been doing is:

ReportSQL = "SELECT * FROM Members ORDER BY MemNum"

Set RS = DB.OpenRecordset(ReportSQL)
Set MemberReport1.DataSource = RS
MemberReport1.Show
RS.Close

i get a type mismatch error. could it be caused by my PROJECT - REFERENCES settings? should i move the priority of the ActiveX data objects 2.0 library higher than the DAO 3.51 object library?