Can't add a record to a subform

[wdsnews]

I have a form that has worked for over a year. However, it's been several
months since I've used it myself, so I wish I had tested it myself before
making changes. It worked fine the last time the regular user tried it.

The subForm is bound to a child table, not a query. The parent form is
bound to the People table. The subForm is linked to the Parent form by a
non-key 'People ID' field.

The database is split between the .mdb and the _be.mdb.

I made three changes today before I discovered it wasn't working. I changed
the defaults for some of the child table fields. I emptied the child table
using a delete query. Finally, I used the same subForm on a different
parent form that is bound to a query.

Is something broken or did I do something wrong? How can I recover the
functionality?

 

[strive4peace]

I am assuming you didn't back it up first? That is, as you probably
realize, the number one rule before making changes...

what do you mean by this?
"The subForm is linked to the Parent form by a non-key 'People ID' field."

It is hard to tell you what to do without knowing more about your
database. for starters:

What is the fieldname and data type of the Primary Key in People?
What is the fieldname and data type of the Primary Key in the related table?
What is the fieldname and data type of the Foreign Key in the related
table that you are using to link to the People record?


Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*