Editing a forms control source to update a field in a table (1 Viewer)

browninaz

Registered User.
Local time
Today, 13:49
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...
 

rzw0wr

I will always be a newbie
Local time
Today, 16:49
Joined
Apr 1, 2012
Messages
489
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
 

browninaz

Registered User.
Local time
Today, 13:49
Joined
Oct 26, 2012
Messages
88
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.
 

browninaz

Registered User.
Local time
Today, 13:49
Joined
Oct 26, 2012
Messages
88
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: 51

Users who are viewing this thread

Top Bottom