The weight field could be included in the RowSource of the Combo874 cbo and need not be visible. Then the AfterUpdate event would just be:
The Column() value is zero base4d so 1 would be the 2nd column
Private Sub Combo874_AfterUpdate()
Me.Text1144 = Me.Combo874.Column(1)
(RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
If your issue is resolved...go ahead and use the Thread Tools at the top of the thread and mark the thread as Solved!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"