Update problems

J

JB

I am having problems updating data in my database. When making edits to
existing records on a form, it often updates the data into the previous
record. This only happens when I make edits and is fine if I add a new
record.

A simplified example, I have two records in this order. Where the company
name is chosen from a drop down list linked to another table.

1 Max Jones, ACME Company, Ph 99999
2 Theresa Smith, Orange Company, Ph 8888

I might go in and update Theresa's phone number and the new phone number
then appears in Maxs' record.

This use to happen to me in Access 97 but I was able to overcome this
problems by some simple programming and saving the record at the press of a
button. This doesn't however work in Access 2002.

Any suggestions would be greatly appreciated. Thanks!
 
D

Dirk Goldgar

JB said:
I am having problems updating data in my database. When making edits
to existing records on a form, it often updates the data into the
previous record. This only happens when I make edits and is fine if
I add a new record.

A simplified example, I have two records in this order. Where the
company name is chosen from a drop down list linked to another table.

1 Max Jones, ACME Company, Ph 99999
2 Theresa Smith, Orange Company, Ph 8888

I might go in and update Theresa's phone number and the new phone
number then appears in Maxs' record.

This use to happen to me in Access 97 but I was able to overcome this
problems by some simple programming and saving the record at the
press of a button. This doesn't however work in Access 2002.

Any suggestions would be greatly appreciated. Thanks!
Click to expand...

This is most definitely *not* normal behavior. Either something is very
screwy about the way your form is set up, or your database is badly
damaged in some way. I'm not sure what programming you may have done in
Access 97 that doesn't work in Access 2002, though the problem there
might be as simple as a missing DAO reference, but no programming should
be necessary to force a form to save edits to the correct record.

If you'd like to send me a cut-down copy of your database, containing
only the elements necessary to demonstrate the problem, compacted and
then zipped to less than 1MB in size (preferably much smaller) -- I'll
have a look at it, time permitting. You can send it to the address
derived by removing NO SPAM from the reply address of this message.
 
Top