I'm not having luck with my code to auto fill a SpRepId field after selecting
the SpRepNam from a combo box in the form.  Both are bound columns.  The
column number refers to the second column in the combo box.  I'm unsure about
why I'm getting an a compile error - invalid qualifier. I'm thinking it's
something obvious but sadly - not to me at this point as this doesn't look
any different from usual.  Can you help? Here's my after update code

Private Sub SpRepNam_AfterUpdate()
On Error GoTo SpRepNam_Err

   Dim DocName As String
   DocName = "frmRepInfoHOwork"

   DocName.SpRepid = DocName.SpRepNam.Column(1)
   
SpRepNam_Exit:
   Exit Sub

SpRepNam_Err:
   MsgBox Error$
   Resume SpRepNam_Exit
   
End Sub