Wrong record update with bound form

[Russ Ferrill]

I have an old Access97 database with bound forms. I have a form on which
data modified in one particular text box gets updated to a different,
seemingly random, record. For example, I have record 12345 displayed. I
modify the data in the text box. I click Next. I click Prev to view the
modified record, but the modification is not there. The record is just as it
was before I changed the data. But, somewhere in the database is a record
that has the change I thought I was making to record 12345. Has anybody
heard of this behavior? Is this a bug or am I doing something stupid? All
suggestions are welcome.

Russ

 

[Pavel Romashkin]

It sounds very wrong. Is the form based on a GROUP BY / DISTINCTROW query?

Pavel

 

[Russ Ferrill]

No, just a couple of inner joins and an order by clause.