3251 - Operation is not supported for this type of object.

[hooi]

I have a subform that contains a call to a subroutine which creates multiple rows of new records depending on the first row of record entered. Near the end of the subroutine, it calls DoSummation (as shown below). Then when I move the mouse to the Parent form, 'error 3251 - Operation is not supported for this type of object' is displayed. What could have gone wrong?

---------------------------------------------------
Public Sub DoSummation()

DoCmd.RunCommand acCmdRefresh
DoCmd.RunCommand acCmdRecordsGoToLast

Me.THours = DLookup("[THours]", "qryServiceTotalHourSpent", "[ServiceID] = " & Forms!ufmService.[ServiceID])
Me.TChargeableHours = DLookup("[TChargeableHours]", "qryServiceChargeableHours", "[ServiceID] = " & Forms!ufmService.[ServiceID])
Forms![ufmService].[TotalPoints] = Forms!ufmService.[TransportPoint] + Me.TPoints

End Sub
--------------------------------------------------

Thanks...

 

[The_Doc_Man]

If all you do is move your mouse, you have a mouse position tracker somewhere. (On Mouse Move event) Look in that first.

 

[hooi]

Actually, when I move the mouse up to the parent form, everything is fine until I click on anywhere on the parent form, then the error message appears. My On Mouse Move event is empty.

 

[hooi]

I've discovered that the problem is caused by the last assignment statement:
Forms![ufmService].[TotalPoints] = Forms!ufmService.[TransportPoint] + Me.TPoints

I've removed it and use another way to do summation. The problem is resolved now. Thanks for helping The_Doc_Man...