I have two tables that I've combined into a query. I want to pull from that query to update a form. Allow for some further input from the user and then save all fields to another table.
In my Employee ID field I have a select query that has a search criteria of WeekEnding. Once the week ending is entered it displays a list all associates with tasks performed that week by Employee ID. After an Employee ID is selected it populates the Employee name from the same query.
This is where it breaks down. I have the query pulling the WeekEnding (obviously by the query) but it isn't populating the WeekEnding field or any subsequant field from the query on the form. I'm thinking it might be a minor tweak on my part but I'm stumped.
Any suggestions?
In my Employee ID field I have a select query that has a search criteria of WeekEnding. Once the week ending is entered it displays a list all associates with tasks performed that week by Employee ID. After an Employee ID is selected it populates the Employee name from the same query.
This is where it breaks down. I have the query pulling the WeekEnding (obviously by the query) but it isn't populating the WeekEnding field or any subsequant field from the query on the form. I'm thinking it might be a minor tweak on my part but I'm stumped.
Any suggestions?
