The value challenge

[chevyimpala]

Okay here is the challenge. I have a form that has a option box, 3 value list , and 2 textboxes. When the user selects all accounts the information from the screen is taken and passed 2 three tables. Each table gets the same info except the quantity which is multiplied by a number. Now what i need to have happen is when they select all accounts, all tables except (Fund) get a value of (Sys1) in the accoutn field, whtn the user has selected sys2, and if the user does select sys2 then the table (Fund) gets that value. Is this posible and does it interfer with the way my system will work.

I have it set up as cases for the option box selections and as insert statments into the tables!!

Thx