SELECT [Clients].[agency_name], [Projects].[invoiced], [Projects].[paid], [Projects].[fee], [Projects].[invoice_date], DateDiff("y",[Now()],[Projects.invoice_date]) AS DaysElapsed
FROM Clients INNER JOIN Projects ON [Clients].[client_id]=[Projects].[client_id]
Works fine in Access as I test it. It does however ask for me to enter the value for the Now() function. Ok. And it returns the records as expected.
However, I need to create a list of these records inside a form control, say a combobox. When I bind the combobox to this query, it still pops up the dialog box for Now(). I thought it was supposed to get this info automatically from my system date