Updating table by reading from other table, help please!

[Rykie]

I have a form that read data from a table in access, but I want to be able to select a value in the form, then when I press the command button I want to write that value I chose from the one table (in the combobox) to another table.

Can anyone please give me some tips??

Much appreciated.... Rykie

 

[KenReay]

Hi

Is there some relationship between the two tables? if yes could you make a query based on the two tables and use that as the record source of your form, then you can update via the form

OR

with an update query

(USING DAO, similar in ADO)

Dim Db as Database()
Dim strSQl as String

Set Db = CurrentDB()

strSQL = "UPDATE tblA SET MyCol = '" & cboBox & "';"
Db.Execute strSQL
Regards

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

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

UK