Save record in form mode

[Troy J]

I am having a problem trying to save a record from a
form. There are ten other forms in the database and they
all work fine. The form with the problem is based on a
query that has several tables, all with a one-to-many
relationship. All relationship permit cascading updates
and deletes. The recordset property if Dynaset. Allow
edits, additions and deletions are all set to yes. I am
at my wits end.

 

[tina]

are you able to add and/or update a record directly in the query's datasheet
view?

 

[Guest]

No. I can see the new record, it appears to save, but
when I exit and return to the form, it's not there.