I have a form with a text box and have the control source set to the function listed below. Payin is currency and end is a date. I get the following error (#error or name ) . I have tried many different configurations to no avail any help would be appreciated.
Thanks Bob
=DLookUp("payIn","tblDepositInformation","[End]= #1/7/2017# ")
Thanks Bob
=DLookUp("payIn","tblDepositInformation","[End]= #1/7/2017# ")