I know I have posted this before, but am having trouble getting a good answer.
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."
Me!tx... Does nott help anything.
Thanks!
*************
M. MARNEY
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."
Me!tx... Does nott help anything.
Thanks!
*************
M. MARNEY