Update Field with value from another Table

[DJJ]

How to I update a description text field on a form with the description from
another table based on an Item Number selected from a combo list? The two
tables are joined on the Item Number. I tried to an update query in the
after-update event on the combo box but it does not work.

CurrentDb.Execute "UPDATE tblMetalUsage LEFT JOIN tblWireTubingSheet" _
& " ON tblMetalUsage.ItemNo = tblWireTubingSheet.ItemNo" _
& " SET tblMetalUsage.Description = [tblWireTubingSheet]![WireDesc]" _
& " WHERE '" & Me.cmbItemNo.Value & "' = [tblWireTubingSheet]![ItemNo]"

This query works fine as a standalone query.

Thanks...

DJ

 

[DJJ]

Actually, I figured it out from an Access Web site. Use the combo box
columns instead of an update query to populate the description field.

Private Sub cmbItemNo_AfterUpdate()
Me.txtDescription = Me.cmbItemNo.Column(1)
End Sub

Column(1) is actually the second column in the list the first being
Column(0).
See link:
http://www.blueclaw-db.com/comboboxlist/multiple_dropdown_fields.htm