i have a form where i'm using a numeric keypad through touch screen.
when pressing the onscreen buttons the numbers and letters should appear on a combo box and when enter the combo goes to the specific record.
Now the preblem is that if i form the code "CH2525" the letters and numbers appear on the combo box ok, and by pressing enter button it gets me to the correct record.
but if i press any number first, the number does not appear in the combo box.
can somebode explain and give me a solution on how to make the numbers appear on my combo box
the code i'm using for the numeric part is
Me.Combo117 = Me.Combo117 & "1"
the code for the letters:
Me.Combo117 = Me.Combo117 & "ch"
even if try Me.Combo117 = "0" will not work
the code in the combobox to get me to the specific record is:
Dim rst As DAO.Recordset
Set rst = Me.RecordsetClone
'rst.FindFirst "[BDCODE]=" & Me.Text121
rst.FindFirst "[BDCODE] = '" & Me.Combo117 & "'"
can somebode explain and give me a solution on how to make the numbers appear on my combo box
thanks in advance
when pressing the onscreen buttons the numbers and letters should appear on a combo box and when enter the combo goes to the specific record.
Now the preblem is that if i form the code "CH2525" the letters and numbers appear on the combo box ok, and by pressing enter button it gets me to the correct record.
but if i press any number first, the number does not appear in the combo box.
can somebode explain and give me a solution on how to make the numbers appear on my combo box
the code i'm using for the numeric part is
Me.Combo117 = Me.Combo117 & "1"
the code for the letters:
Me.Combo117 = Me.Combo117 & "ch"
even if try Me.Combo117 = "0" will not work
the code in the combobox to get me to the specific record is:
Dim rst As DAO.Recordset
Set rst = Me.RecordsetClone
'rst.FindFirst "[BDCODE]=" & Me.Text121
rst.FindFirst "[BDCODE] = '" & Me.Combo117 & "'"
can somebode explain and give me a solution on how to make the numbers appear on my combo box
thanks in advance