Update query based on autnumber field problem

[Maggie24]

Hi all,

I have a form based on a table which has the Product No (autonumber) as the PK.

i ahve an update query which will update fields in my table as follows:

Update tblproducts set primary_material_no = '" & Combo59.Value & "' , secondary_material_no = '" & Cbo_subcategory.Value & "', Updated = 1 where [Product No] = '" & [Product No].Value & "'"


when product no is an autonumber, the query wont work but when i change product no to a text value it does work.

Is there anyway i can use my update query with the Product No field as an autonumber?

Cheers,

Maggie

"Work is the curse of the drinking classes

 

[HaroldGE]

For a Text Field ->
Where [Product No] = '" & [Product No].Value & "'"

For a Numeric Field (don't use single quotes)->
Where [Product No] = " & [Product No].Value

 

[Maggie24]

Thank you Harold, I will try this.

"Work is the curse of the drinking classes