Using a combo box to populate a specific column

[MHernan1]

Hi all, I had a programing question.

Here is an example of what i want to do using (I am just using fruit for clarity)

So lets say i have a table with 4 columns, ApplesAmount OrangeAmount PearAmount and GrapefruitAmount. The information being entered is the number of fruits sold each day.
Now i have a combo box (lets call it "FruitType") that references a separate table i use just for the list of fruit.

What I want is to select the fruit from the combo box, enter the amount in a text field next to it (lets call it "FruitQTY"), hit a button and have the quantity populate in the column that corresponds to the combo box selection.

I am thinking it would require some sort of IF statement, but I don't know the best way of doing that in Visual Basic.
Using an excel example (I know the syntax is probably wrong, but it will give you an idea of what i think is needed) =IF("FruitType" = "Apple", ("AppleAmount" = "FruitQTY), 0)

Any help would be appreciated, even some "if" or equivalent type examples of visual basic code would be great.

thanks!

[MHernan1]

Never mind, I figured it out (i am such an idiot lol)