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
|
|||
|
|||
Posting a Caclulated Value to a data table
I have a Form that has three Text Boxes that are Calculated fields. What I
want to do is to post whatever values are in these boxes into a data table in which I have created fields to receive this data. Thus far the only way I've been able to make this happen is by creating a second Text Box with the Control Source set to the receiving field in the data table and then creating an “On Click Event” for the Text Box, which simply displays the value of the Calculated field in the second Text Box. Of course, this requires the User to Click the Text Box in order for the data to be posted back to the data table. I would like to post this data back any time the User creates a new record or closes out the Form without the User having to do anything. I’ve run up against this one several times in different applications and have never figured it out. Sure could use some help on this one. Thanks, Larry |
#2
|
|||
|
|||
Larry wrote:
I have a Form that has three Text Boxes that are Calculated fields. What I want to do is to post whatever values are in these boxes into a data table in which I have created fields to receive this data. Thus far the only way I've been able to make this happen is by creating a second Text Box with the Control Source set to the receiving field in the data table and then creating an "On Click Event" for the Text Box, which simply displays the value of the Calculated field in the second Text Box. Of course, this requires the User to Click the Text Box in order for the data to be posted back to the data table. I would like to post this data back any time the User creates a new record or closes out the Form without the User having to do anything. I've run up against this one several times in different applications and have never figured it out. Sure could use some help on this one. Thanks, Larry It's difficult because it's a bad idea. Calculated values should not be stored except in very rare circumstances. Create a simple SELECT query on your table and add the three calculations to the query. Then simply use the query instead of the table in any case where you need those values. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I save an access document in word document? | cmartin | General Discussion | 2 | September 13th, 2005 11:26 PM |
Help with relationship plase | Rock | General Discussion | 5 | July 4th, 2005 03:54 AM |
Help with relationship plase | Rock | Database Design | 5 | July 4th, 2005 03:54 AM |
strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
Access & OleDb - generating schema changes, problem with identity/counter fields. | Thomas Tomiczek [MVP] | Database Design | 9 | November 5th, 2004 10:32 AM |