Hello everyone,
I have a form with one unbound textbox field named "languagetxt" where the values it can take are 1, 2, 3 and 4. It works good an according to the language chosen it takes such numbers, it works to change the language to my labels
The issue I have is into the code because when I want to take this value from the unbound texbox field it says it is Null, I don't know how to fix it, i highly apprecitate the help!!
Code:Private Sub Form_Open(Cancel As Integer) Dim language As String Dim key1 As String Dim key2 As String Dim Numberx As String key1 = "[" Number- = Me.languagetxt 'HERE IT'S MY ISSUE BECAUSE IT SAYS THE VALUE IS NULL, I AM NOT SURE HOW TO FIX IT key2 = "]" language = key1 & Numberx & key2 Me.userlbl.Caption = DLookup(language, "[language_tbl]", "[label]= '" & Me.userlbl.Name & "'") End Sub