how to update a one record chosen randomly !?

[anthosss]

Dear all,

i want to make an update query in vba to update one record chosen randomly in a table, below are the data i have :

I have two table with their fields as following:

table1: product
Field1: product name (text)
Field2: product code (text)
Field3: product category (text)
Field4: product price (number)

table2: productUpdate
Field1: product name (text)
Field2: product code (text)
Field3: product category (text)
Field4: product price (number)

i link both tables through the "product category",

i want to update the "product price" field in table1 through adding to only one record in table1 the "product price" from table2 into the "product price" in table1.

any idea ?
thank you