- Jul 7, 2003
I have an MS Access database where I am trying to place a tick in a check box if the Yes\No value in a recordset value is True. Here's a snippet of the code: -
I get the run time error 438 i.e. Object doesn't support this property or method on the .ActiveSheet line. Any ideas anyone?
With objExcelApp If rst!sessioncompleted = True Then .Range("H9").Select .ActiveSheet("Check Box 1").Value = True End If End With