Recent content by LANLJim

EDIT: Thanks CJ, that got me in the right direction. I went into DATABASE TOOLS, then VISUAL BASIC, then selected TOOLS from the menu, and finally REFERENCES. It was indicating a MISSING option for a reference, so I unchecked it. That made the problem go away. Odd that it changed like that.

Here is the query: SELECT Actions.[Action Owner], Main.[Report Type], [Finding Data].[Issue Number], [Finding Data].[Issue Summary], Actions.[Action Number], Actions.[Action Description], Actions.[Due Date], Actions.[Completion Date] FROM Main INNER JOIN ([Finding Data] INNER JOIN Actions ON...

Hi all - Office Pro 2016, Access tables are saved as 2007-2016 format. We have a database that has been working fine. A form allows a user to supply a variable, and a query uses that variable (a name) to inner join other tables and supply a report based on a VBA code for date Date(). Has...