I'm real beginner on creating Access forms. I've fumbled my way through most of it, but am stuck on how to get a calculated value to display onto the screen and also update into a field in the database. Example: Priority, Rank, and Status are all numeric fields entered by user. PriorityFactor is the multiplied product of these three fields. When a user enters or modifies a value in one of the three fields, I want the PriorityFactor to be re-calculated, displayed, and stored. The PriorityFactor value can be 0. Any and all suggestions greatly appreciated.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.