Control Tip to show record from another table...

[MackMan]

Hi all.

Is it possible to have the control tip show related records from another table?

I've been looking around the internet, and I've seen many examples for showing concatenated fields on current record, but had no luck with what I'm trying to do.

For example.

I have a continuous form, and on it shows top line data.
Where a record in this form shows as "Split" it means I have more data related to this record on another table.

Is it possible to show however many fields are related to this record, when I control tip, or mouseover?

I've been playing with

Me.textbox.ControlTipText = Me.textbox

but was wondering, if this is possible, how I'd reference the other table,

If said column of continuous form is "split"...
lookup related table by ID number
show however many columns of data..

Maybe not possible, but I won't know if I don't ask

Many thanks as always.

 

[Ranman256]

you might be able to do on event: ONCURRENT()
Me.textbox.ControlTipText = Dlookup([field],tbl,"[fieldID]=" & txtID)
but this would only show 1 and could bog you down in lookup time.

another way may be, instead of control tip, build a query that pulls the related records.(crosstab?) and join it to your current query.
This new field at the end would be [RelatedRecs].

Hi all.

Is it possible to have the control tip show related records from another table?

I've been looking around the internet, and I've seen many examples for showing concatenated fields on current record, but had no luck with what I'm trying to do.

For example.

I have a continuous form, and on it shows top line data.
Where a record in this form shows as "Split" it means I have more data related to this record on another table.

Is it possible to show however many fields are related to this record, when I control tip, or mouseover?

I've been playing with

Me.textbox.ControlTipText = Me.textbox

but was wondering, if this is possible, how I'd reference the other table,

If said column of continuous form is "split"...
lookup related table by ID number
show however many columns of data..

Maybe not possible, but I won't know if I don't ask

Many thanks as always.

 

[marlan]

I have a continuous form, and on it shows top line data.
Where a record in this form shows as "Split" it means I have more data related to this record on another table.

Is it possible to show however many fields are related to this record, when I control tip, or mouseover?
...
If said column of continuous form is "split"...
lookup related table by ID number
show however many columns of data..

Hi,

The ID number you can use in a continuos form, is the one of the record in focus. Control tip, or mouseover, are not nssaserily on a control in the record in focus.
In other words: all records will show data related to only one record - the record in focus.

ATB