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