Wrong record update with bound form

  • Thread starter Thread starter Russ Ferrill
  • Start date Start date
R

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
 
It sounds very wrong. Is the form based on a GROUP BY / DISTINCTROW query?

Pavel
 
Back
Top