I have a Textbox on my Menu form.  I want to display the next due date [NextRecurring] from a list of recurring payments.  I keep getting a #Name error.  I have set the Control Source for the TextBox to the Query (MenuRecurDateQ).  The query works fine, but the Textbox won't recognize it.  Here is the query SQL: SELECT Min(RecurringT.NextRecurring) AS txtNextRecurring
FROM RecurringT
GROUP BY RecurringT.IsActive
HAVING (((RecurringT.IsActive)=True))
ORDER BY Min(RecurringT.NextRecurring);
Am I using the wrong type of Control?  Is there a better way in VBA?  I want the date to refresh on Load of the Menu form.