Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error Checking Duplicate Forms at data entry?

Status
Not open for further replies.
VoodooRage

VoodooRage

Programmer
Oct 9, 2002
43
US
What is the best way to trap a duplicate record error when the user is entering data? Is the FORM: "OnError" property the best using Dataerr = 3022 or is it better to look for an existing record using the FORM: "BeforeInsert" property?

Thanks,
 
Status
Not open for further replies.

Similar threads

caykamanj1966
  • Locked
  • Question
Duplicate Records in DataSheet View
Replies
5
Views
769
Andrzejek
Andrzejek
kingz2000
  • Locked
  • Question
Bound/unbound forms
Replies
2
Views
704
dhookom
dhookom
renigar
  • Locked
  • Question
Trying to add hyperlinks to pdfs through form entry
Replies
0
Views
563
renigar
renigar
TrekBiker
  • Locked
  • Question
Form Data Not Updating
Replies
6
Views
812
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Duplicate Customers 1
Replies
6
Views
603
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top