>>>>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.
>>>I just tested and had no problem with it. One thing that throws it off... don't include the alias name in quotes in the property sheet.
>>>BTW- I tested with your code _exactly_ except I stored the table name in .tag.
>>
>>Just to clarify: iif(deleted(This.Tag),1,0) in the .Value property. and for the .Tag property you just put the tablename (MyTable instead of ="MyTable")
>>
>>Thanks
>
>I guess you got it to work...?
Nah, see my reply back to Jay.
Mark McCasland
Midlothian, TX USA