I have a check box subclass that has several properties based on the deleted() status of the current record in a table. I have added a property to the class, TableName, where I put the name of the table that the check box properties refer to. What I am trying to do in the properties sheet of the subclass is set forecolor, value and the caption using iif(). For example:
Caption = iif(deleted(This.TableName),"Deleted","Delete")
Value = iif(deleted(This.TableName),1,0)
How can I get deleted() to use the actual value of This.TableName? I have tried stuff like deleted(eval(This.Tablename)), but to no avail.
TIA.
Mark McCasland
Midlothian, TX USA