Missing Values?

J

Julius_Council

I'm using Access 2003.

I developed a form that is designed simply to let you input a name into a
table. That function works fine.

Problem is, I would like to be able to see the names previously entered.
When the form opens it says it's on the first record. I would like to see all
the names because its frustrating to type a name already entered and get the
"CAN"T DUPLICATE VALUES" notification.

This is a simple one I know, I guess I've simply forgotten how to do it.
Thanks.
 
S

scubadiver

I assume you have put the name as the primary key or otherwise stopped
duplicates in the table design?????
 
L

Linq Adams via AccessMonster.com

You've got the form's Data Entry Property set to Yes. Set it to No, instead.
You can still add records if the AllowAdditions Property is set to Yes, and
your form will display all names previously entered..
 
Top