How do I add controls in a form? 2

[ov3rdr1ve]

I have 4 controls that have a number value that I would like to add up.

The thing is I would like to have them add up per record. Since each record will have different values on the controls, I want the added up value to change when you change the record.

I have this working by doing a DSum on fields in the table, but it just continually adds the fields for all the records insead of just the values for each record?

Hope that makes Sence...
od~

 

[TheAceMan1]

How are ya ov3rdr1ve . . . . .

Add an [blue]unBound Textbox[/blue] to the [blue]details section[/blue] and in the [purple]ControlSource[/purple] property copy/paste the following:

[blue] = Textbox1Name + Textbox2Name + Textbox3Name + Textbox4Name[/blue]

See Ya! . . . . . .

 

[pweegar]

What the AceMan suggested does add the values togather, it simply concatinates them. IF you want the values added you need to convert the text values to integers (or whatever number type you need.

Ex.: In the contol source do this : (Converting charter values to integers)

=CInt([textbox1].Value) +CInt([textbox2].Value) + CInt([textbox3].Value) + CInt([textbox4].Value)


Then you can open your table and write the value of the total to what ever field you need. It's also considered bad design to keep totals in your db, but dependingon what I use the totals for, I sometimes keep them anyways.

 

[ov3rdr1ve]

AWESOME!!

Thanks Fellas!
od~

 

[TheAceMan1]

[blue]What the AceMan suggested does add the values togather, [purple]it simply concatinates them.[/purple][/blue]

Apparently you've never tried it!. If you do, you'll find its [purple]coerced properly[/purple], [blue]even across different numeric data types . . . .[/blue]

[blue]Cheers![/blue]

See Ya! . . . . . .