I have been working on this for about 2 days and I really need some help. I am using this following syntax in a form
=DLookUp("[%DM]","[RATION INFO]","[YARD]= forms![BREAKEVEN FRM]![YARD] And [RATIONDATE]=Forms![BREAKEVEN FRM]![RATIONDATE]")
and after I enter this I get an error that says Microsoft can't find the field Form... and then I open the form anyway and it works. Obviously something is wrong in the code. Can anyone take a look and see if they see anything because I use this code many spots in my form.
Thanks in advance.
=DLookUp("[%DM]","[RATION INFO]","[YARD]= forms![BREAKEVEN FRM]![YARD] And [RATIONDATE]=Forms![BREAKEVEN FRM]![RATIONDATE]")
and after I enter this I get an error that says Microsoft can't find the field Form... and then I open the form anyway and it works. Obviously something is wrong in the code. Can anyone take a look and see if they see anything because I use this code many spots in my form.
Thanks in advance.
