Auto-populated and Calculated Fields in Form Help

[jessebh2003]

Hi everyone! This is my first post.

I'm not too savvy with MS Access, but I'm trying. I'm building a form and based on the value of the combobox I want a number to populate in an adjacent text box. Then I want the value of all the text boxes to add up to give me a total. I've watched numerous YouTube videos and read various message boards but all to no avail. Can anyone please help me? Attached is an image of my form.

Auto-populating
My form has three columns (Activity Length, Description, and Point Value). In the Description column, each combobox is a drop down of different values, which are pulled from a table. I want the textbox in the Point Value to auto-populate based on the combo box selection. The point values are also in a table. I've tried =Dlookup but I think I'm doing something wrong.

Example: The first row of my table is Activity Length (ActivityLength_Label), combobox (ActivityLengthDescription), text box (ActivityLengthValue)
Combobox values pull from table (Source Data), column ActivityLength (≤ 3 hours, 4 - 8 hours, 9 - 16 hours, ≥ 17 hours).
Each entry has a corresponding value in column ActivityLengthValues (1, 2, 3, 4).
I want the text box (ActivityLengthValue) to populate from table (Source Data), column ActivityLength based on the selection in combobox (ActivityLengthDescription)

Calculating
Once all of the values populate in the Point Value column, I'd like for the values to add together in text box (ActivitySizeTotalPoints). I've tried:
=sum([ActivityLengthValue] + ...) which results in #Error
=CDbl(Nz([ActivityLengthValue],0))+CDbl(Nz([... which results in #Name?

Example: Here's what I'd like to happen if possible:
(ActivityLengthValue) + (NumberParticipantsValue) + (NumberFacultyValue) + (NumberGrantsValue) + (NumberExhibitorsValue) + (MarketingSupportValue) + (PlanningCommitteeValue) + (TargetAudienceValue) + (ProvidershipValue) + (LocationValue) = (ActivitySizeTotalPoints)

I really appreciate any help that can be shared. Thanks!

 

[jessebh2003]

Hi Micron - sorry, but I don't know how to do that. Access is the one Office product I'm the least familiar with.

 

[Micron]

You must know how to get to the code window if you're writing code, so when you are in that code procedure, click on the blue-gray margin to the left of your code line.
Or there is Google for "ms access breakpoint" or some such similar thing??

 

[jackd]

As Micron advised, you have to select a value from each of the combos, AND it is comboD in my mock up that, after selecting a value, populates the textbox.

I tried to highlight that in post #7.