Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
forcing excel to update the Cell Link when copying Combo Boxes | Excel Worksheet Functions | |||
Cant get a combo box to update without closing form | Excel Discussion (Misc queries) | |||
Combo Box input range automatic update | Excel Discussion (Misc queries) | |||
Auto Update of a field referencing to a field in another workbook | Excel Worksheet Functions | |||
Update Field | Excel Worksheet Functions |