Hello all, I would like the form to auto populate my result in the textbox without me having to click on it to display the textbox. How can i do that? By the way, I am currently using unbound form.
What i am currently doing now is that i write a VBA code to help me differentiate if this is oversea or local branch based on the country.
My code that i put inside my branch textbox on the form:
What i am currently doing now is that i write a VBA code to help me differentiate if this is oversea or local branch based on the country.
My code that i put inside my branch textbox on the form:
Code:
Private Sub txtBranch_Click()
Dim Branch As String
Dim Country As String
Country = Me.txtCountry
If Me.txtCountry = "Singapore" Then
Me.txtBranch = "Local"
Else
Me.txtBranch = "Oversea"
End If
End Sub