Store Value from Synchronized Combo

  • Thread starter Thread starter Pete
  • Start date Start date
P

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
 
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
Click to expand...

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]
 
Back
Top