Hello
I have a subform set up as a continuous form. It shows some product quantities in single units, but I would like the control tip text to show the quantity converted into dozens.
I have written a function to convert the qty and I call it from the MouseMove event of the various quantity controls as follows...
Private Sub txtPlanQty_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
Me.txtPlanQty.ControlTipText = PrsToDozPrs(Me.txtPlanQty.Value)
End Sub
However, the ControlTipText only ever shows the conversion for the record where the cursor is poistioned and not the record over which the mouse pointer is positioned.
The value shown is correct if the user remembers to click in the relevant text box but I know this will soon lead to user error. How can I change my code so that the function is passed the value from the record over which the mouse pointer is positioned?
(Win XP, Access XP, SQL Server 7)
Thanks in advance
I have a subform set up as a continuous form. It shows some product quantities in single units, but I would like the control tip text to show the quantity converted into dozens.
I have written a function to convert the qty and I call it from the MouseMove event of the various quantity controls as follows...
Private Sub txtPlanQty_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
Me.txtPlanQty.ControlTipText = PrsToDozPrs(Me.txtPlanQty.Value)
End Sub
However, the ControlTipText only ever shows the conversion for the record where the cursor is poistioned and not the record over which the mouse pointer is positioned.
The value shown is correct if the user remembers to click in the relevant text box but I know this will soon lead to user error. How can I change my code so that the function is passed the value from the record over which the mouse pointer is positioned?
(Win XP, Access XP, SQL Server 7)
Thanks in advance