subform button visibility

[keaven]

i have a form that contains multiple subforms. one such subform displays records continuously. this form consists of two fields and a button. i'm trying to make the button (for each record) only be visible when the 'date' field is not empty. this is what i have in the oncurrent event at the moment:

If IsNull([Done Date]) Then
Me.Command8.Visible = False
Else
Me.Command8.Visible = True
End If

but ALL of the buttons turn on or off depending on which record has the focus... is there any way to have it treat each record individually rather then all of them as a whole?

[This message has been edited by keaven (edited 12-13-2001).]

[This message has been edited by keaven (edited 12-13-2001).]

 

[pcs]

if you are using a97 or earlier, the answer is pretty much no.

if you are using a2k check help for 'conditional formatting'.

hth,
al