About VB IF ELSE Statement

[Visual Basic]

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