G
Guest
How can avoid entering the same record in a form ??
Sph1197
Sph1197
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John Vinson
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