Editing a forms control source to update a field in a table

browninaz

Ugly Data Hoarder
Local time
Today, 09:02
Joined
Oct 26, 2012
Messages
88
Hello all,

I have created a table for installer invoicing, and have a field for invoice amount. I have created a user input form that allows a user to fill in certain pay rates for different aspects of installation, and would like to know how to make the invoice amount a calculated control that will auto update the field InvoiceAmt in my table. I can't figure out how to do this in the property sheet.

Would someone be willing to help this novice out?

Thanks to all who know more than me...
 
Just a few suggests.
Do the calculations in a query when possible and never store calculated data.

Also like you may not have your table(s) setup correctly.

Can you post a picture of your table(s).

Dale
 
Thanks for the quick response,

I created several queries based on the relevant tables, but my goal is to assign the field that holds the grand total to a form along with fields from other tables to create another calculated control. I am having difficulty with creating a form that I can assign controls from a table and a query and have them calculate. I will send a copy of my structure when I get in front of a computer.
 
Hey Dale,

Heres a copy of my database structure. Take a look and see what you think...
 

Attachments

  • Relationships.png
    Relationships.png
    95.9 KB · Views: 109

Users who are viewing this thread

Back
Top Bottom