How can avoid entering the same record in a form ??
Sph1197
Put a unique Index (such as a Primary Key) on the field or fields
which define a duplicate, in the Table which the form is updating.
You cannot enter records "in a Form". Forms don't contain data; Tables
contain data - you enter the records *using the form as a tool*, and
the form stores them in the Table.
John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
