When the user initiates "keydown" for the txtSSName field, I want the keystroke rembered and added to a dropdown field where it will start auto filling. This is what I have so far and keycode appears to be a numeric value for the letter entered and it is not working. I'm connected to a SQL db if that helps.
Objective: What I want is for the txtSSName to display the Support Staff(SS) for the current client. However, if the user clicks on txtSSName I want to go to a dropdown field where only the CURRENT SS names are listed. If I use only the combo box for my form (and filter out Non Current names) the name doesn't display on the form if the SS is not current. If there is a better way to do this I'm open for suggestions. Right now I'm displaying txtSSName field on top of cboSupportStaffLkUpID.
Private Sub txtSSName_KeyDown(KeyCode As Integer, Shift As Integer)
strKeyCode = KeyCode
Private Sub cboSupportStaffLkUpID_GotFocus()
cboSupportStaffLkUpID.SelText = strKeyCode