Hi,
I am using Microsoft Access 2016. I am creating a database that will allow a user to create a schedule that tells employees to test specific orders that a customer places and also allows them to record the data. The schedules are ordered by date. Right now, I have an Intro Form that allows the user to choose where to navigate in the database. The schedules are under the "Schedules" button, as shown below:
When clicked, a list of all of the available dates of schedules appear, as shown below.
I want the user to be able to select which date they want to view the schedule for and open up a form that shows the schedule for that date (the form should be filtered by that date). I have created similar filtered forms before, and I have never had any issues. With this form, though, when I click the "Select" button, I get an error that says "Syntax Error in JOIN Operation". For the button I used macros, and this is what I have in my macros for the button:
To filter the next form based on the date, I would typically include the statement ="[Order_Date]="&[Order_Date] in the "Where Condition" section, but I have taken that out because I thought that might be where the error was coming from. It is not, butI've researched the error, and it seems like this is a typical issue with a query. I myself did not create a query manually, and I'm no expert on queries by any means, but I did use a form wizard to create my form, and in the Record Source of my form it shows which table the data is coming from, and behind that I believe a query is created (or something like that - again, I'm no expert, this is just what I have observed). In this query that seems to have been created by Access, this is what I see:
I am at a loss for how to fix this. Any ideas?