how do I change an index to duplicates(yes) in a form?

M

Mr. Muzz

I created a form from a datasheet setting the controls there. I realized
after entering data that I mistakingly set a feild to be indexed with no
duplicates. However I need it to have duplicates. How do I change it in the
form without redoing it? (I am new to Access - learning as I go)
 
D

Dirk Goldgar

Mr. Muzz said:
I created a form from a datasheet setting the controls there. I
realized after entering data that I mistakingly set a feild to be
indexed with no duplicates. However I need it to have duplicates. How
do I change it in the form without redoing it? (I am new to Access -
learning as I go)
Click to expand...

The index isn't in the form, but in the table design. Open the table in
design view and change the index there. That's all you need to do.
 
K

KARL DEWEY

Indexes are in the table not form. Open the table in design view andclick on
menu VIEW - Indexes. Click on that index and set property to Duplicates Ok.
 
Top