I'm just now learning how to use Microsoft Access, and 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 corresponding, racial modifier text boxes. Example: If I select gnome as my race, it will populate the [ConRacial] text box with a 2 and the [StrRacial] text box with a -2. I also want the information in these text boxes to update corresponding fields on my Characters Table.
So far, I have everything figured out except for how to update the racial modifier text boxes on my form once the race has been selected. Is there a way to do this using an AfterUpdate event of some kind?
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.
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 corresponding, racial modifier text boxes. Example: If I select gnome as my race, it will populate the [ConRacial] text box with a 2 and the [StrRacial] text box with a -2. I also want the information in these text boxes to update corresponding fields on my Characters Table.
So far, I have everything figured out except for how to update the racial modifier text boxes on my form once the race has been selected. Is there a way to do this using an AfterUpdate event of some kind?
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.
