Can't enter data in form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is driving me crazy. I have a working Access database. I wanted to
redesign some of the forms and get rid of unused queries. I can't make
changes to the db while other users are in it. Rather than make a copy of
the db, I decided to start with a brand new, blank database. I imported in
all of the tables. I am importing in queries and forms as needed. I have a
form that I imported in--I made no changes. I can edit the fields iin the
form in the old db; I can't edit any fields in the form in the new db.

Both forms are based on the same query (generated in code in the main form
that calls this form. Both forms have "Allow Edits" set to yes. The field I
want to edit is not locked. I have other forms in the new db that I can edit
(which makes me think it is not a global setting).

If anyone has any idea what would be keeping me from entering text in a
field on the new form (that is an exact copy of the old form) I would really
appreciate your help.

Thank you,
Judy
 
Check to see if you have a primary key in your imported tables. Access will
usually delete (or not import) the primary key from the imported table into
the new one.

Let me know if this helps.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top