update table via combo box (using sql)

[donnie051280]

i need to update a field within a table with the results displayed in the combo box.
all the fields in that particular table are to be updated with the combo box results

thanks

 

[KenReay]

Hi

I am assuming you mean all the rows need to be updated

In the after update eevnt of the combo

Dim strSQL as String

strSQL = "UPDATE YourTableName SET YouColumnName = " & cboName & ";"
DoCmd.RunSQL strSQL

Note if it is couln is a string

you need

strSQL = "UPDATE YourTableName SET YouColumnName = '" & cboName & "';"



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK