I wouldn't use IIF in the caption property. Mayvbe it can be done, but it appears that it isn't working for you...

I would set the caption in a method and then refresh the control...

Joe

>I have a label on my form that I would like to control the caption based on the value of a field in a table. The label has the correct value in the 1st record, but the caption does not change when the form is refreshed with a new record. However, I have noticed that when I return to design mode the caption appears to be have the value of the last retrieved record. Am I missing something?
>
>Here's my code:
>
>lblAmount Caption - IIF(credit, "Credit", "Debit")
>
>cmdNext Refresh - SKIP 1 IN detail
> IF header.batchno <> detail.batchno OR
> header.glseqno <> detail.glseqno
> SKIP 1 IN header
> ENDIF
> ThisForm.Refresh
>
>TIA for your help. :)