I POSTED A SIMILAR QUESTION WITH MREXCEL (JUST JOINED ALSO)
I WOULD LIKE TO LEARN HOW TO USE BOTH ACCESS AND EXCEL FOR THE SAME END PURPOSE
I DISCOVERED ELOOKUP AND THOUGHT IT WAS BETTER BECAUSE OF THE ERROR MSG
I FORMATED THE ELOOKUP THE SAME AS DLOOKUP BUT IT SEEMS TO BE DIFFERENT
I HAVE A 2 FIELD TABLE A STRING & B A # AND I AM LOOKING UP THE #
ANSWER= DLOOKUP(# "TABLE",FIELD) PROBLEM SOMETIMES DOES NOT WORK BUT NO ERROR FLAGGED
TRIED THE SAME WITH ELOOKUP
ANSWER= ELOOKUP(# "TABLE",FIELD)
I GET A ByREF ERROR SO I THINK I FORMAT ELOOKUP WRONG
I AM THANKFUL FOR ALL THESE GREAT FORMS OF PEOPLE TRYING TO HELP EACH OTHER
THERE IS STILL HOPE FOR THE WORLD TO SURVIVE MY GENERATION MADE A MESS OF