Error Message Duplicate Name

  • Thread starter Thread starter tom
  • Start date Start date
T

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????
 
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!
 
Back
Top