Help on VBA/SQL update query.

[T 5]

Dear All,

Could I ask for some help in coding a VBA update query please?

I have a table tblPriceList which contains a field SupplierID.

I want to create an Update query in VBA/SQL, in an after-update event of a combo named Combo45.

The SupplierID’s within the table I want to change will be equal to a value shown in a text box (on a form) called txtDispVariable. I want all the ID’s to change to the Combo45 bound column.

I am not sure if this is required but, Combo45 and txtDispVariable are located on the same form called frmProductSuppliers.

Not sure if there are any other details required.

Thanks and regards

[orange]

see Martin Green's tutorials on vba/sql

[ranman256]

It will be something like:

UPDATE tblPriceList
SET [SupplierID] = " & forms!frmProductSuppliers!Combo45
where [SupplierID] = " & forms!frmProductSuppliers!txtDispVariable