Total's Box

[Bike]

This is the last thing i seem to be stuck on,



Basically on my repairs form i have these fields to enter data.

[Serial #]
[Invoice Number]
[Mechanic's Last Name]
[Date Of Job]
[Duration of Job]
[Work Description]

I have a query that runs the totals for me, but i was wondering how i would go about creating a text box or whatever suites it best to generate the total as i type in the duration of job ( in hours ex. 1.50 ) at the rate of 50$/hr for example.

Or would making some sort button to run the query for this particular repair only and display the results on the form be the easier route?

[Accidental DBA]

The easiest route is to create a new Macro. Use SetValue as the first line, and set the control to your total field. Then in the expression argument, set your query as the argument. Set the second line to Save record. Leave the arguments blank, and save the macro. Then for each field on your form set the "After Update" property to run your macro. Then as you update your fields is will calculate, and replace the value in the total field. Hope this was helpful.