Here's the problem I have now...
=DLookup("Due_Diligence_Email", "Docs Request", "Sheet1.ID = 1")
This is tied to form with a drop down box that gets the data from a query. If I have 1, then it only works for that 1 selection. How do I get it to just use the active record in the query?