While normalizing some poorly designed tables today I discovered that I broke a form that had formerly been based on a query. Now, with my new junction table relationships, I couldn't have a query as the source any longer since it wasn't updateable. So, I dropped on the junction data into subtables and based the form off of its source table.
However, I had formerly offered a number of combo boxes to create where criteria to filter the form on load that were based on fields that were related through the query. Fields like FirstName LastName etc. Now these fields are found in a subform of the main form and so, I can't open the form using those combo/where filters any longer.
I can only imagine that I need to somehow create a recordset or query to apply the where criteria against and then based the form open on that new recordset. Unfortunately, I've not delved into recordset creation before so I'm only guessing that that is the solution and I have no idea where to start.