Combo box connection with code

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
 
R

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
 
Top