How to?

[answergirl]

I am new to visual basics and totally stumped as to how to write a code that will take the data in a form with clculated percentages and place them in a specific field in a corresponding table. Am I expecting too much of Access to get it to do the following:

1.) created Data input form
2.) placed % filed that calculates amount from another field e.g. Annual Salary contains the amount that places in the FICA field the amount due, as well as the same setup for Retirement
3.) set up relationships
4.) the form is entering all the correct data and calculations but is not filling the information into the table that it should.

I thought a VB code would help the form fill the table. Am I right? If so, though I have been trying to write the code I am failing.

Any assistance is helpful

 

[fiep]

You do not need VB code to fill tables. If you select a table as the recordsource of the form and select fields from the table as the recordsource for textboxes etc. the records in the table will be updated with the values you enter in the form.

W.

 

[answergirl]

If there are formulas-calculations in a form it will not come over into the table. I need the calculations in the table too not just blank fields.

 

[hermanlaksko]

On of the rules of "databasing" is: newer save calculations.... Why ???
Becourse the figs on witch these calculations were based on keep changeing :-D
So that is a no-no.
Calculate-as-you-go and you will get the correct answers everytime - if your calculation is correct ;-)

Herman

They say that crime doesn't pay... does that mean my job is a crime?