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

[browninaz]

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]

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]

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]

Hey Dale,

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