What is the equivalent of the following VB
6.0 code in VBA (using Access 2000):
Dim rst As Recordset
Set rst = DB.OpenRecordset("SELECT * FROM TEMP")
So far I have:
Dim temprec As Recordset
Set temprec = CurrentDb.OpenRecordset("SELECT * FROM TEMP;")
Basically I want to copy everything that is in the table "TEMP" into my recordset so that I can fill variables with the values in "TEMP."
I currently get an error that tells me that the query must have at least one destination field.
Do I need to create a querydef first?