Hi can i use the if else statement to decide on the information go to specific tables that i create?? The form that have fill up will be send to the table 1 or table 2 that i created at ms sql 2000 base on the user write active or not active. So do it work like that ?

Something like

If data="no active" then send to table 1
ElseIF data="active" then send to table 2
End 
EndIf
If data="no active" then send to table 1
    strSQL = INSERT INTO Table1...
ElseIF data="active" then send to table 2
    strSQL = INSERT INTO Table2...
EndIf

BTW: You should never use the END statement to stop your program.


Good Luck