Form

[wendy1967]

How do I store the data from the form to the table? Ex. I have some calculations on the form that I want store on the table so that I could develop a report using the information from the table.

 

[ssteinke]

First things first, determine what kind of data you want to store, create the tables to store that data, then create the forms and reports. Not having anymore information I would caution you however not to 'store' calculations. Calculations should be performed on raw data at runtime.

That said, binding the form to the table can be as simple as making the table your forms Record Source which can be found in the form's properties.

Once that is done, bind your textboxes and other controls by setting their Control Sources to reflect the appropriate fields in your table.

~Scott

 

[wendy1967]

Scott,

Thank you for your prompt reply. The calculations are based on payroll.

 

[ssteinke]

You're welcome for the reply.

If you need more help, please be more detailed in the analysis of your problem. Also provide more specificity to your question. You will get better and more detailed answers.

~Scott

 

[wendy1967]

Detailed Explanation

Scott,

The Pay table has these fields:
Start Date, Time In, Time Out, Daily Rate and Overtime Rate

The frmPay has these fields above plus:
Daily Pay
Overtime Pay
Total Amount Pay

These fields has a calculations and I want to store them to Pay table. Then I would like to be able to use the data from Pay table to develop my reports.

How can I do this? Do I need to put all of the fields from the frmPay to Pay table? I really appreciate your help.

Wendy

 

[ssteinke]

Wendy,

If you can perform the calculations in the form at runtime, use the same method to perform the calculations in the report at runtime. I would not suggest 'storing' the calculations in the table as this generally goes against rules of normalization.

How are you populating those additional text boxes on your form?

~Scott

 

[wendy1967]

Calculation - Form

~Scott,

For the additional text boxes on the form, I've created a query that calculates Daily Pay, Premium Pay and Total Amount Pay.

Then I've used the same query to develop the form. Therefore, the query is populated with all of the data that I need to create the report.

Wendy~

 

[ssteinke]

I'm not sure i'm understanding, maybe someone else could jump in here... or if you can cut your dbase down to only the objects we are discussing, zip it up and post it, i'll take a gander at it.

~Scott~
~~~~~