Form/Table Locked

[tom]

I'm at an impasse! I have a form associated with a table. When the
database is opened I have it set so the form opens first. Somewhere
along the way I did something wrong however I can't seem to go back
and fix it.

Once the form is opened it can't be closed. When I try to close the
form, go into form design or even try to close Microsoft Access I get
the message "Date name is a duplicate. Change the value." I've tried
changing the value, nothing works. I can't get to the table except in
a "read-only" mode.

Sigh, hopefully someone can help me. I've spent a lot of time
designing the form and I don't want to start over. Any advice would
help. Thanks

 

[Rick]

You should not name any of your controls or fields "DATE" as this is a
reserved word and will cause conflicts (as you have discovered).


I'm at an impasse! I have a form associated with a table. When the
database is opened I have it set so the form opens first. Somewhere
along the way I did something wrong however I can't seem to go back
and fix it.

Once the form is opened it can't be closed. When I try to close the
form, go into form design or even try to close Microsoft Access I get
the message "Date name is a duplicate. Change the value." I've tried
changing the value, nothing works. I can't get to the table except in
a "read-only" mode.

Sigh, hopefully someone can help me. I've spent a lot of time
designing the form and I don't want to start over. Any advice would
help. Thanks