Subform field value in continuous form?

M

Michael D

I have a combo field with Member Id numbers in a continuous subform. I want
to code in the 'MouseMoveOver' event the Member's name in the combo's
ControlTipText field. To do this I need to be able to uniquely identify the
'value' or MemberId number that is in each MemberId combo field. At present I
get the same MemberId number when I identify the value of the cboMemberId
field, even though the MemberId numbers are all unique. I'm only getting the
value of the first occurrance of the cboMemberId field.

Can anyone help with how to uniquely get the value of the cboMemberId field
when I use the MouseOver event?

Thanks... Michael
 
D

Dirk Goldgar

Michael D said:
I have a combo field with Member Id numbers in a continuous subform.
I want to code in the 'MouseMoveOver' event the Member's name in the
combo's ControlTipText field. To do this I need to be able to
uniquely identify the 'value' or MemberId number that is in each
MemberId combo field. At present I get the same MemberId number when
I identify the value of the cboMemberId field, even though the
MemberId numbers are all unique. I'm only getting the value of the
first occurrance of the cboMemberId field.

Can anyone help with how to uniquely get the value of the cboMemberId
field when I use the MouseOver event?
Click to expand...

I think Stephen Lebans may have a solution for this on his website. Go
to

www.lebans.com

and poke around a bit.
 
M

Michael D

Hi Dirk

Thanks for this hint. I've actually already looked at his ToolTipVer34 files
and these are excellent, but they don't answer my problem of referencing the
unique data in each row of a subform field.

Can a MouseMove Event pick up the 'value' of the underlying field in a
subform field with continuous rows?

Thanks... Michael
 
D

Dirk Goldgar

Michael D said:
Hi Dirk

Thanks for this hint. I've actually already looked at his
ToolTipVer34 files and these are excellent, but they don't answer my
problem of referencing the unique data in each row of a subform field.

Can a MouseMove Event pick up the 'value' of the underlying field in a
subform field with continuous rows?
Click to expand...

See this page instead:

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.
 
M

Michael D

Dirk

I found this file and have adapted it to my program. It is brilliant even
though I don't understand all the code it's great to learn from.

Thank you very much.

Michael Daly.
23 August 05
 
Top