Set value too complex???

[redblaze]

hi, i want to set the value of a field twice...if that makes sence. i have a check box and a status box. if i click the check box so that its value is 'true' then the status should change to "avaliable". But then if i click it again so that the check box is 'False', the status should change back to "on Loan". iv tried using the conditions but have not got anywhere! is there any way of doing this without any VB?

 

[Rich]

For the control source of status
=Iif([Checkbox]=True,"Available","OnLoan")