Before Update

[Larry]

When a user is adding a new part number I would like to
add a BeforeUpdate statement that verifies if it already
exists in the database and if does; have it display a
error message " This is already in the database,. Please
verify the Part number".
TIA

 

[Allen Browne]

Use DLookup() to see if the value is already there.

See:
Getting a value from a table: DLookup()
at:
http://members.iinet.net.au/~allenbrowne/casu-07.html

 

[Guest]

This is what I need.
Thank you
PS GREAT SITE!

-----Original Message-----
Use DLookup() to see if the value is already there.

See:
Getting a value from a table: DLookup()
at:
http://members.iinet.net.au/~allenbrowne/casu-07.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.




.