Tell me where i went wrong

[Vbbeginner07]

want to check all the textboxes are filled and then only we can insert into the database.
i have used the textboxes is clear code
likewise

if text1.text = "" then
msgbox"enter data"
With txtid
.SelStart = 0
.SelLength = Len(txtid.Text)
.SetFocus
End With
Exit Sub
elseif text2.text = "".......like wise
'
'
'
else
conn.execute "insert into..........

but elseif is not executing
tell me where im wrong
Thanks in advance...

[debasisdas]

You need to use nested if for the purpose since using EXIT SUB.

[Vbbeginner07]

You need to use nested if for the purpose since using EXIT SUB.

Im not able to get u ..little bit elaborated

[creative1]

Try something like this:

if text1.text = "" then msgbox"enter data"
With txtid
.SelStart = 0
.SelLength = Len(txtid.Text)
.SetFocus
End With
Exit Sub
IF text2.text = "".......like wise '
'
'
else

Endif ' End of inner IF statement
Endif ' End of Outer If statement

conn.execute "insert into..........

[debasisdas]

Im not able to get u ..little bit elaborated

Hope the previous post clears your doubt.

[Vbbeginner07]

Try something like this:

if text1.text = "" then msgbox"enter data"
With txtid
.SelStart = 0
.SelLength = Len(txtid.Text)
.SetFocus
End With
Exit Sub
IF text2.text = "".......like wise '
'
'
else
Endif ' End of inner IF statement
Endif ' End of Outer If statement
conn.execute "insert into..........

that too wasnt making out..............!!!

[debasisdas]

that too wasnt making out..............!!!

try this

if text1.text = "" then msgbox"enter data"
With txtid
.SelStart = 0
.SelLength = Len(txtid.Text)
.SetFocus
End With
Exit Sub
else
IF text2.text = "".......like wise '
'
'
else
 
Endif ' End of inner IF statement
Endif ' End of Outer If statement
 

[Ali Rizwan]

want to check all the textboxes are filled and then only we can insert into the database.

I m afraid of this y u all not maintain readability of ur programe.
Use tabs for clean coding.

When u use tabs like

if text1="" then
msgbox "None"
else
      if text2="" then
      msgbox "None"
      end if
end if

now u know where s the end of first if and where is for second and debugging is easy.

When u r posting any question try to put code quotes around code

Regards

>> ALI <<