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...

Dec 21 '07 #1

debasisdas

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

Dec 21 '07 #2

Vbbeginner07

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

Im not able to get u ..little bit elaborated

Dec 21 '07 #3

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..........

Dec 21 '07 #4

debasisdas

Im not able to get u ..little bit elaborated

Hope the previous post clears your doubt.

Dec 21 '07 #5

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..............!!!

Dec 21 '07 #6

debasisdas

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

try this

Dec 21 '07 #7

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

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 <<

Dec 21 '07 #8