Store Value from Synchronized Combo

[Pete]

Private Sub ProcessStep_AfterUpdate()
Me.Equipment.RowSource = "SELECT Equipment FROM" & _
" QryEquipment WHERE ProcessStepID = " & Me.ProcessStep & _
" ORDER BY Equipment"
Me.Equipment = Me.Equipment.ItemData(0)
End Sub

How do I store the resulting value from the above Synchronized Combo
box in a table, so that the value is remembered as part of this
particular record.

Pete

 

[John Vinson]

Private Sub ProcessStep_AfterUpdate()
Me.Equipment.RowSource = "SELECT Equipment FROM" & _
" QryEquipment WHERE ProcessStepID = " & Me.ProcessStep & _
" ORDER BY Equipment"
Me.Equipment = Me.Equipment.ItemData(0)
End Sub

How do I store the resulting value from the above Synchronized Combo
box in a table, so that the value is remembered as part of this
particular record.

Pete

Set the Control Source of the combo box Equipment to the name of the
field where you want the selected value stored. And delete the
Me.Equipment = line - it makes no sense; it's just setting the value
of the combo box to the value of the combo box, prior to the user
selecting a value from the combo box!

John W. Vinson[MVP]