Copy autofill primary key field to another field

[Sham]

Hello guys,


I head is frozen, My table called Table1 has a primary key field (called RefID) with AutoNumber format. My problem is I want duplicate value of RefID field to another field called DupID. I want DupID to be changed, but I don't want any change on RefID field whenever I make changes. Does anybody have any idea??

Thank you,
Really appreciated.....

[RuralGuy]

What have you tried so far? I don't see any problem as far as Access is concerned.

[Sham]

I created a query with all fields from the table, and added a new field on query to store duplicate data. Typed Expr1: RefID in the new field, field name. Now I get all duplicate data of RefID in DupID. But I can not change DupID, I think because of the source field is AutoNumber format..

[RuralGuy]

I created a query with all fields from the table, and added a new field on query to store duplicate data. Typed Expr1: RefID in the new field, field name. Now I get all duplicate data of RefID in DupID. But I can not change DupID, I think because of the source field is AutoNumber format..

I believe you cannot change the field because your new field contains a formula. I thought you were doing this in the BeforeUpdate event of a Form.

[Sham]

I believe you cannot change the field because your new field contains a formula. I thought you were doing this in the BeforeUpdate event of a Form.

yes I used a form, ok thank you so much, I'll find some other solutions if i can....

[RuralGuy]

So you got it to work using a form, right? Are you ready to mark this thread as Solved?