Updating entries without duplication

[Guest]

have a form that allows customers to input personal data. My problem is
that when a user wants to update his info (such as his phone number) he goes
back and fills out the form again. What I get now is 2 entries from this user
with different info. What I want is 1 entry with updated info. Is it possible
to tell 1 column ( such as email address) that if it is duplicated to just
overwrite the other fields in this entry?

 

[Arvin Meyer]

Far better to educate the user by doing a DLookup in the BeforeUpdate event
of the control for that field. If the email address exists, inform the user
and make him look up the correct record. That way, the next time it happens
he/she is less likely to just open a new record. I make my users look
through the database before entering a new record. They are unable to even
enter a new record unless they have tested for it first.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

The problem is that my users only access my form on my web page which then
sends the data to the database. they dont have access to it directly.

 

[Arvin Meyer]

So only give your users a capability to search from the first web page.
Don't even expose the new record button until after the search page.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access