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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Doubled record

Status
Not open for further replies.
rogerarce

rogerarce

Technical User
Jan 24, 2002
57
CR
Hi.
I need to know how can I avoid a record to be included
twice from a form. Thanks for your time.

 
Sort by date Sort by votes
By the proper use of unique index.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
in the table, set the field for which you don't want duplicate values to: Indexed Yes (No duplicates)


Pampers.

You're never too young to learn
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

caykamanj1966
  • Locked
  • Question
Duplicate Records in DataSheet View
Replies
5
Views
737
Andrzejek
Andrzejek
DB_Bowes
  • Locked
  • Question
Selection from Listbox to GoTo Record in Bound form Gives Error 2105
Replies
1
Views
360
DB_Bowes
DB_Bowes
priac
  • Locked
  • Question
Create a Duplicate of an Existing Record in Microsoft Access but leave some fields blank.
Replies
7
Views
1K
Andrzejek
Andrzejek
TrekBiker
  • Locked
  • Question
Print labels for each subform record 2
Replies
8
Views
453
TrekBiker
TrekBiker
StevenFromSouth
  • Locked
  • Question
Delete record from one table if it does not exist in another 1
Replies
15
Views
506
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top