Combo box connection with code

[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

 

[Ron2006]

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