'How to have Textbox in a form to show correct autonumbering ID from Query?

Combobox has 3 columns. Employee name, ID, Phone.. Textbox2 should show the id and textbox3 shows phone. issue is my id number in the table and query is 220005 but the ID Textbox, "textbox2", shows "5" ... Combobox does show Id as 220005. Any suggestions?

Private Sub EMP_Change()
Me.ID = Me.EMP.Column(1)
Me.Phone = Me.EMP.Column(2)
End Sub`
formseventscomboboxms-access-2016autonumber


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions