I thought I was done with this one but a user who is testing my DB just pointed out a problem.
I used the following in the afterupdate event:
Expand|Select|Wrap|Line Numbers
- Private Sub Binding_Percentage_AfterUpdate()
- 'Updates the Total calculation in the control "SumGWP", Sum50GWP, "SUMNWP" and Sum50NWP
- 'on the quick reference table on the Forecast form.
- Me.Refresh
- End Sub
Basically, once I change the Binding_Percentage and tab into another field on the same row my numbers (My unbound controls that are performing a calculation) change appropriately but the minute I click on to another row (using the mouse or tab) on my table the numbers change. It looks like the numbers change to the old settings. When I click back to the row I changed, the numbers go back to what they are supposed to reflect. I changed the code to the following:
Expand|Select|Wrap|Line Numbers
- Private Sub Binding_Percentage_AfterUpdate()
- 'Updates the Total calculation in the control "SumGWP", Sum50GWP, "SUMNWP" and Sum50NWP
- 'on the quick reference table on the Forecast form.
- Me.Dirty = False
- Me![SumGWP].Requery
- Me![Sum50GWP].Requery
- Me![SumNWP].Requery
- Me![Sum50NWP].Requery
- End Sub
I read that if a Control is unbound, the many instances of this Control on the Continuous Form will display the same value in all instances. Therefore I would need to somehow bind the Control on the Continuous Form if I need to display different values in its instances.
Does that make sense to anybody out there, so far I am not getting it..
Any ideas would be great,
Keith.