I want to check all the textbox and combo box if its null or not. Once they click on the button, if one txtbox or combo box is null it will give a message that incomplete entry. I have already posted this thread, but i noticed that when the txtbox or combo box is on the tabcontrol it will not check if its null or not. Here is my previous code.! Any suggestion or just revision of my code in order for this work.?My code below:
Sub clarifydata() Dim mycontrol As Control For Each mycontrol In newstudentry.Controls If TypeOf mycontrol Is TextBox Or TypeOf mycontrol Is ComboBox Then If Trim(mycontrol) = "" Then toclear = toclear + "1" 'C.SetFocus Else toclear = toclear + "0" End If End If Next If toclear Like "1" Then clarifyclear = True Else clarifyclear = False End If End Sub
God bless on this mother earth.