Hiding controls on a continuous form

[wodonnell]

I have a continuous form which I which displays as follows:

Persons_Name Persons_Email <Button>

Persons_Name Persons_Email <Button>

Persons_Name Persons_Email <Button>

etc.

If this were a report then I could use the OnFormat event to change the format of each row depending on the values of the fields.

I have a field which indicates whether or not an email has previously been sent. This is included on my form but is hidden.

When the button is pressed, an email is sent to that user.

Is there any way in which I can say, "If an email has already been sent (E_Sent="Yes") then don't display the button (button.visible=False)

So, for example, on the form above, if the 2nd entry had already been sent the email then the button would not be displayed.

Persons_Name Persons_Email <Button>

Persons_Name Persons_Email

Persons_Name Persons_Email <Button>


I have so far only been able to hide either ALL the buttons, or NONE of them, rather than just those which match my criteria.

 

[Rich]

You only need one button in the FormFooter, it then becomes just a case of using the FormCurrent event