Report help - Cannot ref. Object

[mdmarney]

Here is the current code:
It works great in a form, but not in a report.

Dim rs As Object
Set rs = CurrentDb.OpenRecordset("Select * from tbl_Attendants Where Tee_Shirt_Size = 'L'&quot
rs.MoveLast
Me.tx_L_Count = rs.RecordCount

**The error is on the assignment to the text box line.**
It says, "You can't assign a value to this object."

Thanks! *************
M. MARNEY

http://www.tgw.com

 

[vbajock]

Me.tx_L_Count = rs.RecordCount

probably should be

Me!tx_L_Count = rs.RecordCount

 

[mdmarney]

No, same error... *************
M. MARNEY

http://www.tgw.com