AboutRichard Rost Expertise I am happy to answer any kinds of questions about Microsoft Access - from basic table design to advanced VBA programming. Also, please feel free to check the Access Tips & Tricks section of my web site.
Education/Credentials I am a self-taught Access expert. I have been building databases for clients since the early 90s. You can see a sample of my Access Tutorials on my web site at 599CD.com
Question I am attempting to create a formula that will alter itself according to a list box the users choose from. For example:
List Box will allow either 'a' 'b' or 'c'. This will couple with a basic number input in another cell. A different cell displays the equation =[List Box]+ [Other Cell (extraneous formula not displayed)]. So if the final value in 'Other Cell' is equal to 30 depending on the users choice a could change it to 32, b to 48, etc. I have an intermediate level of understanding Access. Thank you for your time.
Answer You can use an AfterUpdate or BeforeUpdate event to set values, change properties, run macros, and do lots of other cool things.
The major difference between the two is that BeforeUpdate runs BEFORE the data is saved to the table, which allows you to CANCEL the update if the data is not valid. AfterUpdate runs after the data is saved to the table.
Please see the following FREE video tutorial on my web site for step-by-step instructions on how to create an AfterUpdate event:
P.P.S. I volunteer my time at AllExperts to help people, and I get a LOT of questions, so I can't take an hour to answer each question. If you need more DETAILED HELP, come to my TechHelp web site at http://www.599cd.com/TechHelp/AllExperts and I'll take as much time as you need to answer your question.
