robn
Posts: 70
|
| Posted: 07/25/2006, 7:48 AM |
|
I have an interesting little problem (well I think it is anyway)
I have a form that holds a combined total for a record from another table. The calcualation for this figured is derived from the other table. so basically when in the main form (for table opportunity) with say the ID=4 the calcualation looks in table ValueBreakdown for any records that have a foreign ID of 4 and calculates the total of these records. This provides the figure to go into the main form (opportunity). To do this I placed an Before Show event against the field which looks like this
tblOpportunity.TotalGrossValue.Value = CCDLookUp("sum (DollarValue)","tblValueBreakdown","id=" & DBssso_001.ToSQL(CCGetFromGet("id",0),ccsInteger), DBsso_001)
this code works perfectly when loading the form. The problem I have is when the form has loaded there is a popup link which allows the user to change/add/delete the related tblValueBreakdown records. So after the popup has been updated it closes and updates the TotalGrossValue field on the main form. I know this could be done with a page reload but if possible I would like to avoid this and just refresh/reload the value in TotalGrossValue.
Any help or ideas on this would be much appriecated
I'm using ASP with SQL2000
Thanks in advance
Rob
|
