Access Query_Form

[Jimmy2128]

I have an access query that place an email into my form, my criteria is the following

IIf([Name].<>'',[dbo_Name].[EMAIL] & Chr(13) & Chr(10),'')

But , I have an additional field for the members that dont want to have their email publish. Does anyone could advice me the best way to not include those unwanted emails on my form...

Regards,

James

 

[PaulBricker]

You don't say what the addtional field is for members that don't want their email published, but if it's a checkbox, then in the OnCurrent Event for your form, you can toggle the Visible property for your email field on and off based on the value in the other field.

Paul

 

[Jimmy2128]

YEAP SORRY IS A CHECK BOX... THANK YOU