I'm having issues trying to get this code to work. It's supposed to take the number "CountofIndividualFish" in "qry2012" with the criteria1 = [Text161] (which is a text box with control source =Right([Set_Date],4) AND [CollectorID] which is a combo box on the form the user selects before they enter the Set_Date.
Private Sub Set_Date_AfterUpdate()
[Text159].Value = DLookup("CountofIndividualFish", "qry2012", "CollectionYear=" & Forms!frmCommercial2!Form1!Text161 & "AND CollectorID=" & Forms!frmCommercial2!Form!CollectorID)
End Sub
Any help would be GREATLY appreciated...
-Fish