If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Forms
I am kind of new to access and I keep running into some small problems. I
have a table that needs to be manually updated. So I created a form to input the needed info. Inside that form there is a caculation on 2 of the txt boxes, so the user dosen't have to input that information. My problem is that when the user puts in all the needed information the table will update everything that the user put in except for the information that was automatically caculated. How can I get my table to update that information as well? Thanks in advance |
#2
|
|||
|
|||
Forms
Don't.
Database normalization rules state you don't store values that can be calculated. You have all the fields necessary for the calculation in the record. Rather than store a calculated value, do the calculation, as you are now, on the form and on a report. -- Dave Hargis, Microsoft Access MVP "Tiff" wrote: I am kind of new to access and I keep running into some small problems. I have a table that needs to be manually updated. So I created a form to input the needed info. Inside that form there is a caculation on 2 of the txt boxes, so the user dosen't have to input that information. My problem is that when the user puts in all the needed information the table will update everything that the user put in except for the information that was automatically caculated. How can I get my table to update that information as well? Thanks in advance |
Thread Tools | |
Display Modes | |
|
|