I'm trying to use Dlookup to grab thes value in a field from a query. It works if I copy the values to a table however I want to avoid this if possible. Here's the code below
Private Sub Form_Load()
Dim MyDate, MyDay, MyYear, ent1, ent2, ent3, ent4, ent5
DoCmd.OpenQuery "qryCalcDifference"...