Gday Guys
I have a table which lists river styles and their values scores. Some of these values are the same for different river styles. I am trying to create a combo box in a form which displays the river style and assigns the score to a separate table (which is displayed in a text box) for later calculations. The problem I have is Because the values scores are not unique for each row the combo box list will only allow the user to select the river style which is the first in the table to have the same value score! Is there a way around this? I was thinking that an If then statement would do the trick but I'm not to familiar will VB and don't know how to make it work! any tips you could give me would be very greatly appreciated.
Cheers
I have a table which lists river styles and their values scores. Some of these values are the same for different river styles. I am trying to create a combo box in a form which displays the river style and assigns the score to a separate table (which is displayed in a text box) for later calculations. The problem I have is Because the values scores are not unique for each row the combo box list will only allow the user to select the river style which is the first in the table to have the same value score! Is there a way around this? I was thinking that an If then statement would do the trick but I'm not to familiar will VB and don't know how to make it work! any tips you could give me would be very greatly appreciated.
Cheers