Error Message Duplicate Name

[tom]

Hopefully someone can help, I've done something dumb. I have built a
table with an attached form. Dutifully read thru this group and have
added several features to the form. Everything was hunky dory until
today. When the database opens I have it set to open the form. When I
attempt to either go into design mode or even close the form I get the
following message:

"Date name is a duplicate name. Change the value."

I can only access the table in read-only mode because the form is
open. Sigh... any ideas as to what have I done or what I can do to
correct it????

 

[PC Datasheet]

It sounds like you have used "Date" for more than one field name in yoour table.
Open the table in design view and check the field names.

Another thing --- if you have used "Date" for a field name, you need to change
that. "Date" is a reserved word in Access and using it for a field name will
eventually give you problems!