469,159 Members | 1,494 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,159 developers. It's quick & easy.

Write Conflict.... subform conflicting with parent form?

I get the "this record has been changed by another user since you started editing it" message when I first make an edit in a subform then click on anything in the parent area. It won't give me the option to save, just "copy to clipboard" or "drop."

Both the parent and the subform use the same table in their RecordSource. The only difference being that, the subform has a RecordSource that joins a 2nd table in its query.

When I edit (within the subform) a textbox that is bound to the 2nd table, I don't get any locked out message. But when I edit a textbox bound to the first table (the table which is also used by the parent), then I get the locked out message.

The parent does not actually update any data. It merely reads a record.

How can I make it save, without that lockout message?
Jun 10 '10 #1

✓ answered by Parmenides

I guess that wasn't the problem. Newbie mistake. I added a new column, and Access didn't like the nulls for bit columns.

Everything is fine now

2 2100
I guess that wasn't the problem. Newbie mistake. I added a new column, and Access didn't like the nulls for bit columns.

Everything is fine now
Jun 10 '10 #2
MMcCarthy
14,534 Expert Mod 8TB
Good to know, glad you sorted it out.
Jun 10 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by shumaker | last post: by
reply views Thread by manning_news | last post: by
4 posts views Thread by crystal | last post: by
1 post views Thread by S.Dickson | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.