Question About Updating one table with data another table using a Form

[DoveArrow]

Okay, I feel a little silly telling you guys this, but I'm just going
to come out and say it: I play Dungeons and Dragons, and since I'm
still learning how to use Microsoft Access, I thought that it might be
fun to try and build a character sheet database at home so that I
could play around with some of the program's features. Unfortunately,
I'm running into a snag. Here's my problem:

I have a table, called 'Characters Table,' which is updated using a
form called 'Character Sheet.' What I want to be able to do is select
a race from a second table, called 'Races Table,' using a combo box,
and have it populate a couple of text boxes with something called a
racial modifier. Example: If I select gnome as my race, I want my form
to populate a text box, called [ConRacial], with a 2 and a second text
box, called [StrRacial], with a -2. I also want the information in
these text boxes to update corresponding fields on my Characters
Table.

Now all of these racial modifiers are listed in the Races Table for
each race. What I want to be able to do is update the racial modifier
text boxes on my form by selecting the race from a combo box, and have
it update my 'Characters Table.' Is there a way to do this?

Please keep in mind that I am very much a n00b at this (I just learned
how to use Select Case statements like two days ago, and these were my
first ventures into using the VBA Code Builder features of Access), so
you'll need to speak slowly and patronizingly in a way that a total
amateur can appreciate and understand. Thanks.

 

[Guest]

Hmm...if you like using the wizard, just go to the properties box and program
something into the "after update" event to make all the math changes after
the combobox has been changed.

 

[DoveArrow]

Hmm...if you like using the wizard, just go to the properties box and program
something into the "after update" event to make all the math changes after
the combobox has been changed.

Okay, I feel a little silly telling you guys this, but I'm just going
to come out and say it: I play Dungeons and Dragons, and since I'm
still learning how to use Microsoft Access, I thought that it might be
fun to try and build a character sheet database at home so that I
could play around with some of the program's features. Unfortunately,
I'm running into a snag. Here's my problem:

I have a table, called 'Characters Table,' which is updated using a
form called 'Character Sheet.' What I want to be able to do is select
a race from a second table, called 'Races Table,' using a combo box,
and have it populate a couple of text boxes with something called a
racial modifier. Example: If I select gnome as my race, I want my form
to populate a text box, called [ConRacial], with a 2 and a second text
box, called [StrRacial], with a -2. I also want the information in
these text boxes to update corresponding fields on my Characters
Table.

Now all of these racial modifiers are listed in the Races Table for
each race. What I want to be able to do is update the racial modifier
text boxes on my form by selecting the race from a combo box, and have
it update my 'Characters Table.' Is there a way to do this?

Please keep in mind that I am very much a n00b at this (I just learned
how to use Select Case statements like two days ago, and these were my
first ventures into using the VBA Code Builder features of Access), so
you'll need to speak slowly and patronizingly in a way that a total
amateur can appreciate and understand. Thanks.- Hide quoted text -

- Show quoted text -

If I understand what you're saying, you're suggesting that I use
something like a Select Case statement, where if the person selects
gnome, rather than pulling the data from a table, it pulls it from a
routine. I've actually thought about doing that, but I want to make
the database easily updatable, and if someone wants to add a new race,
I want them to be able to fill in a few fields on a table, rather than
having to go in and modify code.