field name reference

[mikej336]

I have a table with obscure field names. So I put their descriptions in a table.

I want the control tip text to look up the field name in a table and have it display the description.

I have DLookup("Desc", "Fieldlist", "FName = 'AMACCT'")

but I cannot figure out how to reference the current field name so I can just create a function.

Something like forms!main.currentfieldname

Thanks

Uncle Mike

 

[mikej336]

MS Access by the way.

 

[PHV]

Screen.ActiveControl.Name ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[mikej336]

Excellent, thanks...

Uncle Mike