Mouse Move Event

[Guest]

I have a form displaying records in a continuous format. There are 4 fields
on the continuous form. I have a mouse move event for field1 on the form
that displays the contents of field 2 in another field on the same form.

The problem is that when I put the cursor over the 2nd or 3rd entry on the
continuous form, it always displays the 1st entries information. Is there a
way to get at the 2nd or 3rd rows information?

 

[Stephen Lebans]

See:
http://www.lebans.com/conformscurcontrol.htm
ContinuousFormsCurrentRow.zip is a class that allows you to programmatically
access the contents of a bound control, as the user moves their Mouse, but
the control does not have the focus. For Forms in Continuous View.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Guest]

thank you for your reply...

however, when the mouse moves over row 1, it dispays the contents of row 2,
when the mouse moves over row 2, it displays the contents of row 1 and when
the mouse moves over row 3, it displays the contents of row 2 which means it
never displays the contents of row 3.

I had to convert it from Acc97 to Acc2002 for my project, could that be
causing the problem?

 

[Guest]

additionally, when I have the form display the row number:

row 1 = -1
row 2 = 0
row 3 = 1
row 4 = 2

etc.

 

[Guest]

sorry...once I looked at the code, I discovered that it will only work if
scroll bars are turned on for the form...I enabled vertical scroll bars and
it worked fine...thanks again for your help..................

 

[Stephen Lebans]

Glad you figured it out yourself. I was getting ready to answer you.<grin>

--
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.