Form Text Box populated by other row in form not updating in spreadsheet or editable

[grkatz823]

My form is currently set up so that the 'material' is a drop-down list containing two columns, the name of the material and the unit of measurement (feet, meters, liters etc...) used for that material. When I pick one from the list the Material row updates with the name of the material and the Unit row updates with the unit. I did this by making the control source of the unit textbox '=[material].[column](1)'. However, when I use this formula, the 'unit' textbox does not move the unit info to the appropriate spreadsheet where the data should be stored, nor is the textbox editable (enabled is 'yes', locked is 'no').

Is there a better way to automatically populate the 'unit' field so that it is editable and updates the main table?

[RuralGuy]

Populate the "unit textbox" from the AfterUpdate event of the ComboBox (drop-down) instead of the ControlSource of the "unit textbox".

[grkatz823]

I tried doing [Unit].[ControlSource]([material].[column](1)) from the AfterUpdate event of the combobox but I don't think that's the correct expression as it isn't doing anything. Even if it was, how or why would it change anything?

[RuralGuy]

What you want in the AfterUpdate event is:
Me.[unit textbox] = Me.material.[column](1)

[grkatz823]

Put it in the code builder and it worked. Thanks

[RuralGuy]

Glad we could help.