Mouse Over/Hover Over

[nndatabase]

Can someone help me? I have a field called Project Code. When I mouse over the field I will like a small description of the Project to appear. This information will be pulled from another table.



Can you tell me how to do that?

[pbaldy]

I would probably set the ControltipText property of the textbox in the current event of the form. You can use a recordset or DLookup() to get the description, using the currently displayed project as a criteria.

[nndatabase]

Thank you...however the ControptipText doesn't seem to allow for any coding but more static.
The code I'm trying to write (Im still learnin VBA) is this.
When I hover over the Project Code, I want to display the Project Name of the code.
The Project Name is found in a table call tblNNNN Codes
How would I write the Dlookup code?

DLookup()

[pbaldy]

Yes, I know, that's why I said I would set it in the current event of the form. This type of thing:

Private Sub Form_Current()
  Me.TextboxName.ControlTipText = DLookup(...)
End Sub

DLookup() syntax here:

DLookup Usage Samples