runtime error 3022

[smarbu]

Hi:
I am getting that error message" runtime error 3022" along with the message "there is a duplicate value in the primary key" after this line of code runs:
me.requery

Any tips on what I'm doing wrong or where I can go to check for possible problems?

I am new at this--posting your problems--thing, so let me know if I need to give you more 'symptoms'.

thanks,
smarbu

 

[ReAn]

It means that your query is somehow returning TWO record with an identical primary key value.

For instance, if your table has a field called "ID" and that is set as a primary key, it means all entries in that colunm must be unique. So, this means that somehow you're getting non-unique results for that field.