Cursor move to display Custom form.

[smtazulislam]

Hello any help will be appreciate,
I have a Continuous Forms. In this form I would like to display my second form "frmMirrorForm".
for that i used,

Private Sub Detail_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
DoCmd.OpenForm "frmMirrorForm", acNormal, "Name= " & Name, "EmployeeID=" & Me.EmployeeID, , acWindowNormal
End Sub

Its work.
But I should Click the ROW and move the mouse pointer Then displayed.

Can is it display only the move the mouse pointer ? and How to do that ?

 

[arnelgp]

it will work and show Same record again and again.
using mouse move event does not change records.

 

[smtazulislam]

it will work and show Same record again and again.

What is the solution sir ?

EDIT : Its work not showed same record if I click any record this show this records. Its perfectly work.
But I only need if I will move the mouse then its display the form.

 

[isladogs]

If you only have a small number of records with no vertical scrollbar, you may be able to adapt the approach I used with a mouse move event and a listbox in this example Move Forms & Controls - Mendip Data Systems. Look at forms 4 & 5 in the example app.

 

[smtazulislam]

Look at forms 4 & 5 in the example app.

I downloaded your Form.
But I would like when I move my mouse then display my form.
Exp: My mouse pointer is in the EmployeeID-2 row. If you move my mouse in the employeeID-3 then display the form with Employee-3 Data.
My form is work well but without click not display. And I dont like to click or Double click
Because, I have 35000 rows to checking...

 

[isladogs]

As already stated, Form4 in my example app does exactly what you want - see attached video
However, it identifies the record under the mouse cursor by accurately determining the position of the cursor relative to the form on screen.
For that reason, the approach used is only suitable for a small number of records where there is no scrollbar.

It is definitely no use at all for 35000 records.
As @arnelgp stated earlier, you cannot use a 'conventional' mouse move event for this as the record isn't selected until it is clicked.
Moving the mouse over the records will always display whichever record was previously selected.
I believe you are out of luck!