linking cells within a table 1

[topgun43031]

i have a table with a rec'd cell and an assigned cell
i want to subtract assigned cell from rec'd cell into an ONhand cell. can we do it ?

 

[DougP]

Put this code in the After update event of the "Assigned" FIELD, "Cells" is used in Microsoft Excel "fields" are used in Access.

me!OnHand = me!Assigned - me!rec'd

So if you have all three text boxes on your form bound to the table, the data in the form will be written back to the table.



DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.

 

[topgun43031]

thanks dougp,i will try this, my email is viper@ecr.net if you can send me an attachment showing me how to do this ....thanks.. topgun43031

 

[JerryDennison]

I strongly recommend that you do not store calculated results in your table. This is contrary to good database procedure and goes against the forms of data normalization. You can and should however re-calculate this amount on demand wherever it is needed. For example, to display this amount on your form with the other values you need only add an unbound text box with the following in it's controlsource property:

=[rec'd] - [assigned]