Code to update table value based on another value

[rileyjm]

I'm trying to update a table value based on another value in the same table.

Here's the scenario:

In the table I have 3 estimate descriptions: Sizing, Planning and Commitment. Each description is tied to a series of numbers representing estimates across different teams. For example:

Estimate_Type Team 1 Team 2 Team 3
Sizing ................0........ 0......... 0
Planning .............0........ 0......... 0
Commitment....... 0......... 0......... 0


I currently have all 3 estimate types default to all zeroes when a new team is added to the table. The teams then enter their respective values in the Sizing estimate field. Most commonly, their Sizing estimate will end up equaling the same value as their Planning and Commitment estimate....so, I would like the values for the Planning and Commitment estimates to update automatically when the Sizing estimate changes. My first thought was to use dLookup but I wasn't sure how to make this work. Would I have to run VBA code to sync up the 3 estimates?

This would be easy to accomplish in Excel, but I can't seem to think of a solution for Access. In Excel, I could simply place a reference to the cell with the sizing estimate into the cells for Planning and Commitment. Looking for something comparable in Access??

Thanks in advance.

 

[SpentGeezer]

The table needs to be in a form as a subform.

Create a form. Use the Subform / Subreport tool to add a subform. Use the wizard to set it up for you. In design mode view the properties of the sizable textbox on the new subform. Create an event for the "After Update" event that does this:

Private Sub Sizable_Change
planning.value = sizable.value
commitment.value = sizable.value
end sub

See the attached SGA example..