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'"
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
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'"
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