Auto Fill data in textbox from Combobox selection
Where the combobox is:
ManagerID stored as a number but displayed as text when selected
Location ID stored as a number but displayed as text when selected
Table Field s for Managers
ID   AutoNumber
Manager Text                        
LocNo Number
Location Text
E-mail Address Text

Table  to store data
RecordID AutoNumber
Date Date/Time
ManagerID Number        
(ComboBox Drawing Data from Managers Table displays Text but store Number, ID & Manger)
LocationNo
(ComboBox Drawing Data from Managers Table displays Text but store Number, LocNo & Location)
LocationNo Number
Request Text
FeeID Number
Cost Currency
TicketNo Number

On my from I had used a Combo box For Request that when I select item the Cost auto populates from the combo box. I used the following after update code.

#Private Sub FeeIDCombo_AfterUpdate()
ReAllocatedCost = DLookup("Cost", "Re-Allocated_Cost_Fee_T", "FeeID=" & FeeIDCombo)
Me.Refresh
End Sub#

Which works great.  
I tied the same logic with the manger and Location but could not get it to work.
Can this be done? Is it because ComboBox is Drawing Data from Managers Table displays Text but store Number, ID & Manger)?

I also tried making an unbound combo to store the value and tried the following code:

#Private Sub FeeIDCombo_AfterUpdate()
Me.ManagerIDTextBox = Me![ManagerIDComboBox].Column(0)
Me.BranchTextBox = Me![ManagerIDComboBox].Column(1)
Me.Refresh
End Sub#

I have been at this for days. Is this possible with values that are Number but display as text?
What am I doing wrong, any incite or direction would be greatly appreciated.