On one of my Access 2000 forms (AuctionForm), I am getting an #Error in a textbox control. I'm not sure what’s causing it, since I’m used to getting event errors that let you debug; but this just quietly shows up as #Error, right in the control. Also, it’s not consistent. If I activate and view another form, and then go back to the AuctionForm, the #Error is sometimes gone, replaced by the properly calculated value.
The textbox where the #Error appears (called TotalPaid) has a Control Source property set to =[AuctionPmt Subform].[Form]![Text10].[Value]. Text10 is a control in the subform that adds up all the payment values in that subform. Whatever value appears in Text10 should appear in TotalPaid.
The AuctionForm (where TotalPaid is) has an OnActivate event procedure:
Private Sub Form_Activate()
Dim auPK As String
auPK = Me!EbayNum
If Me.Dirty = True Then
Me.Dirty = False
This event is used to refresh the AuctionForm each time it is viewed.
Any reason why the #Error?? I am unable to tell if the #Error is in the subform.Text10 control, or if it is occurring BETWEEN Text10 and the TotalPaid control.