ExcelBanter - Combo box update to field

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Combo box update to field (https://www.excelbanter.com/excel-discussion-misc-queries/147980-combo-box-update-field.html)

Esrei

Combo box update to field

Hi

I am new to code

I have tried Tom Lake's sugestion

Private Sub Combo12_AfterUpdate()
Me![Ingredient_Id] = Me![Combo12].Column3
End Sub

Ingredient_Id is a textbox number format must update to a table.
Combo12 (unbound) looks up a list in a query and the 4th Column in the query
is the ID that must be inserted in the text box to be updated to the table

What does the me mean?

Thank you

Esrei

Esrei

Combo box update to field

Sorry wrong group

"Esrei" wrote:

Hi

I am new to code

I have tried Tom Lake's sugestion

Private Sub Combo12_AfterUpdate()
Me![Ingredient_Id] = Me![Combo12].Column3
End Sub

Ingredient_Id is a textbox number format must update to a table.
Combo12 (unbound) looks up a list in a query and the 4th Column in the query
is the ID that must be inserted in the text box to be updated to the table

What does the me mean?

Thank you

Esrei

All times are GMT +1. The time now is 11:14 PM.