Data has changed message - Unbound text box w/ AfterUpdate event Sub

[Max Moor]

Hi All,
I'm using some unbound text boxes on a tab page to display, and allow
changing of some values in a table. I init the boxes in the Form Open
event Sub. I use the AfterUpdate event to update the values in the single
record table with an UPDATE SQL statement.

The problem is that... If I change the value of a box, then click
on the next box to change it, when I type the first character in the second
box, I get a message saying that:

"The data has been changed. Another user edited this record and saved the
changes before you attempted to save your changes. Re-edit the record."

I'm the only user on the database, so this message doesn't make a lot
of sense to me. All I know for sure is that I don't want my users to have
to put up with it.

Can anyone explain this to me, and offer a possible fix?

Thanks, Max

 

[MacDermott]

Although your textboxes are unbound, is it possible that the form itself is
bound (has a value in the RecordSource property)?
In that case, the form itself and your SQL statement count as 2 users,
who are trying to update the record independently of each other.

HTH
- Turtle

 

[Max Moor]

Although your textboxes are unbound, is it possible that the form
itself is bound (has a value in the RecordSource property)?
In that case, the form itself and your SQL statement count as 2
users,
who are trying to update the record independently of each other.

HTH
- Turtle

Yes!!! That was exactly the problem. I changed how I do a couple of
things, and got rid of the form's record source. Works like a charm.

Thanks!
Max