I have several DLookups in my 2003 version that work fine, but when i upgrade the db to 2007 they do not work. Is the syntex different in 2007?
Here is just an example of one of them used in a form.
=DLookUp("[Name]","[FMLA_Yearly List]","[FMLA_ID]=[Forms]![FMLA Log]![FMLA_ID]")
I search other threads and i get a couple different syntex, but none of them work.
Thanks in advance for any help
Here is just an example of one of them used in a form.
=DLookUp("[Name]","[FMLA_Yearly List]","[FMLA_ID]=[Forms]![FMLA Log]![FMLA_ID]")
I search other threads and i get a couple different syntex, but none of them work.
Thanks in advance for any help