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
|
|||
|
|||
form/table
Hello all,
I have a form field that performs a calculation based on two other fields in the form. How can I get that result to show up back in the table upon which the form is based? Noguy |
#2
|
|||
|
|||
Proper database design would dicate that you do not store any calculated
fields in the table. When you need to use that calculated information, you can perform the calculation in the query, report, or form that you are using. Storing it in the table would be redundent. Rick B "Noguy" wrote in message ... Hello all, I have a form field that performs a calculation based on two other fields in the form. How can I get that result to show up back in the table upon which the form is based? Noguy |
#3
|
|||
|
|||
As was said in the other reply, it's probably not a good idea.
However, access aint the snappiest of DBs, and it may be necessary to cache some info in this way. In fact, it's standard, nay, required! to store calculated info for certain schemas. In any case, what kind of calculation are you attempting? If it is possibly, you should make a query that does the calculation for you, and then use that query as the source of the form. If you do have to save the data this way, you could just bind a control to the field in the table, and then call a little sub that does the calculation and sets that textbox's .value and then refreshes the form to save (me.refresh). HTH On Tue, 24 Aug 2004 13:59:23 -0700, "Noguy" wrote: Hello all, I have a form field that performs a calculation based on two other fields in the form. How can I get that result to show up back in the table upon which the form is based? Noguy ..-------------------------------------- | Andrew Backer | backer_a @ h0tmai1 dot com `-- |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Default values to load up automatically in a form based on value entered in another form | Anthony Dowd | Using Forms | 8 | August 12th, 2004 08:53 AM |
how to get data from form/table into query | Elsie | General Discussion | 6 | June 20th, 2004 03:13 AM |