ControlTip Text filter

[Gepetto]

I need to show in ControlTip Text filtered result from three table fields.
How to do that?
Help!!!

 

[pono1]

One way to do this is to use a table of tips, VBA, DLookup, and your form's current and afterupdate events...

Option Compare Database
Option Explicit

Private Sub Form_AfterUpdate()
  
  UpdateControlTips
  
End Sub

Private Sub Form_Current()

  UpdateControlTips

End Sub


Private Sub UpdateControlTips()

    Me.TextBoxName.ControlTipText = DLookup("Field_Name", "Tip_Table_Or_Query_Name", _
                          "[Field_Name] = Form![TextBox_Name]")
                          
    'Etc.

End Sub

Regards,
Tim

 

[Gepetto]

Thanks a lot!