Find when certain item selected from multiple pull downs and use value

[MajorYoshi]

Hi all,

Bit of a complex one for me as I'm not stellar on queries and SQL or VB are right out!

I am making a form to allow all of our local Battletech players to create a character sheet and print it out. I've got it working quite well and am trying to add some nice little touches to it.

The main form is for all the character data EXCEPT skills. For the skills I have a subform (as they're saved in a separate table) that has 48 pulldown boxes for them to select their character skills from (skill list in another table to populate these pull downs) as they're inputting their character data. Next to each of the pulldowns is a text box that is to be used for a number that represents the skill level. The max number for a skill is 10.

What I would like to happen is if they enter a specific skill (I only have two different ones that I need to query on) I want to grab the number in the skill level box and use that in another text field in the main form (so I can do a calculation on it and provide this number for them).

The fields in the subform are defined as such:

NC_Skill_1 (through 48) for the pulldown box for the skill name.

NC_Skill_Num_1 (through 48) for the associated skill level.

So, if any of the NC_Skill_# pulldowns say 'Running' I want to grab the number in the associated NC_Skill_Num_# and use it in the main form.

Now, to make this easy, I could just use a text field that says 'Running' and put it at the top or bottom of the list and then just use the skill level number associated with that without going through this. But, I like to make things clean (and apparently much more complex)...

I greatly appreciate help.

Thanks,
MajorYoshi

 

[MajorYoshi]

One other bit of information, in case it makes a difference in this, is my character skills table where the pulldown boxes and text boxe entries are saved to.

The table is 'CharacterSkills'. In this table I have an autonum primary key, 24 fields set up for combat skills, 24 fields to have the associated numbers for the combat skills, 48 fields for non-combat skills, and 48 fields for associated non-combat numbers.

So, each character's skills appear in one long row if you look at the tables.

dunno if this makes a difference.

Thanks again.