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. :)