Set Me.Recordset = rst thinks its a field??

[SeanB]

My form when I am trying to set the Form Recordset gives me an error can't find field recordset. Why would this happen? I think I have everything right I am dim a new recordset and all that??

 

[LonnieJohnson]

Is this how you have your code?

Dim rst As Recordset
Set rst = Me.RecordsetClone

Looking at your title it looks like you have the rst varible on the wrong side of the equal sign.

B-) ljprodev@yahoo.com
ProDev, MS Access Applications

http://www.galaxymall.com/software/PRODEV

 

[SeanB]

Dim strsql As String
Dim rst As New ADODB.Recordset

strsql = &quot;SELECT tblCustomer.PoRef1,tblCustomer.PoRef2,tblCustomer.AdminComments,tblCustomer.DispatchComments,tblCustomer.CustCode, tblCustomer.StateLocation, tblOrderStatusCodes.OrderStatusOrder As StatusCode,tblcustomer.custid as CustCustID,t.*,case when t.OrderDate<convert(varchar(11),getdate(),113) then 2 else case&quot; & _
&quot; when t.OrderDate>convert(varchar(11),getdate(),113) then 3 else 1 end end AS ColorID &quot; & _
&quot; FROM tblOrders As t INNER JOIN tblCustomer ON t.CustID = tblCustomer.CustID INNER JOIN tblOrderStatusCodes ON t.OrderStatusCode = tblOrderStatusCodes.OrderStatusCode &quot; & _
&quot; WHERE t.OrderStatusCode In ('AA','AD','AP','AS','RR','CB','PB','RB','HD') AND t.PickUpDate < getdate() AND tblCustomer.StateLocation IN (Select State from tblUserStateFilter where SessionID = &quot; & Trim(gSessionID) & &quot&quot; & _
&quot; ORDER BY StatusCode, t.OrderStatusCode, t.PickupDate, t.VehicleType, t.PickupTime , t.OrderNumber &quot;

rst.ActiveConnection = CurrentProject.Connection
rst.CursorType = adOpenKeyset
rst.LockType = adLockOptimistic
rst.Open strsql
DoCmd.Echo False
Set Me.Recordset = rst
DoCmd.Echo True
End Sub