Hello,
I'm looking for some logic on my Access form. Currently, I have "email" set as a primary key so when someone enters a new email address it pops up saying the record already exists. I have a simple error check VBA message for this currently which brings up the message box.
My problem is from that point on, even if you blank out the email field it keeps giving you an error until you enter in something unique. And I have to manually remove it from the table.
I would like to expand the logic to point out if the record already exists based on the email field, and if so, ask the user if they would like to edit the the information. If Yes is selected, have it bring up the record they tried to enter inside the forum so they can change name or address information.
If No is selected, then do nothing and allow the user to enter a different email if desired.
I tried writing this code - but it doesn't really work:
Thanks in advance!
Bookmarks