Forums

This topic is locked

Duplicating Data in Field When Updating a Record!

Posted 15 Aug 2002 18:45:13
1
has voted
15 Aug 2002 18:45:13 Gavin Beddow posted:
Sorry if this query has been posted before, I did a search but can't find anything!

Anyway, I'm having a real nightmare with the updating of a record in an access database!

The main problem is that I am unable to recreate the error that my client is receiving.. Everytime they update a record, the data in each field is duplicated i.e. in a surname field after the update is submitted, the user name becomes smith,smith! The comma appears in the actual field!

I have never experienced this problem before, and as I mentioned, I can not re-create the problem on my pc!

Can anyone help? It would be greatly appreciated!

Thanks,

Gav

Replies

Replied 16 Aug 2002 07:15:03
16 Aug 2002 07:15:03 Travis Brown replied:
Hard to tell without seeing the code. I assume the insert was created with UD?

Easiest thing to do if it was created UD is delete and reapply the insert behaviour. When inserting a record, UD submits the values back to the form page and then executes the insert. If the UD code was modified, I guess the values could be doublely submitted. You can get comma seperated values when submitting identically-named form objects.
I don't know why you can't recreate it. Post the code and I'll have a look.

Reply to this topic