I would like to either display a field on the view page based on a entry made on the add/edit page.
Each new entry will be from a member that can either allow their email to be displayed on the view page or not.
I have a field called "Sapre11" which has a drop down box to choose either "Yes" ot "No" and the email field is "UserEmail".
my Access database is called tblproperties
I would like the follwing to happen each time the View page is loaded.
To check to see if the value "Spare11" is "Yes" or "No" and if "Yes" display the value of "UserEmail" on the View page.
Can anyone please help with this issue, I thank you in advance.
Steve