Combo box connection with code

  • Thread starter Thread starter Crazyhorse
  • Start date Start date
C

Crazyhorse

I know I close. It displays the number of the first column which is the
autonumber. I want it to display the text in the field called FileLocation.


Private Sub CboFileName_AfterUpdate()
Me!txtFileLocation = Me!cboFilename
Endd Sub

Thanks
 
Assuming that the displayed field is the second field in the query
that is the source of the combobox information.


Private Sub CboFileName_AfterUpdate()
Me!txtFileLocation = Me!cboFilename.column(1)
End Sub
 
Back
Top