Add selected numbers from across fields and display real time

[euroclyde]

I am trying to display a total based on 3 separate combo boxes in a form. there is a name with an associated number value using 2 fields. the values come from a linked value spreadsheet. the name field is "text" and the number is "number". the user selects their name and number using a combo box drop down window. this occurs 3 times in my form and i want to sum them in a 4th combo box. this is about how it should look, where "Total" happens automatically depending on the name selected.

Lewis 3 Smith 2 Parks 2 Total= 7

thanks for helping.

dave

 

[ronculbert]

Not sure if this is what your looking for but might help

I was not sure if you wanted the name and number in the same drop down?

 

[euroclyde]

I got the name and number in the same drop down box by calling on a worksheet with 2 fields and then selecting to display 2 columns rather than 1. What's weird, however, is when you click to drop the window down you see both fields but when you select the name you want, the number field is not displayed.

 

[euroclyde]

I'm looking at the design view of the sample you provided but don't see anything that tells "total" where to get the value from. help.