Ok, this is a little complicated, so here goes:
Customer Info Form = customer information
Work Order Sub-Form = a subform within the customer info form that lists all work orders associated with that customer
Details form = a separate form that should show a detailed list of tasked completed for a given work order number. There is no primary key for this table and form as I need to be able to list several records related to a single record from the "Work Order Sub-form".
What I want is to be able to double-click on a work order on the "work order sub-form" and have the "Details form" appear with all entries associated with that particular work order number.
I'm using a macro with a "where" clause to accomplish this (which usually works) but for some reason this set up is causing a pop-up window to appear asking for a work order number (which should already be selected when I click on the work order record, right?), then opens up the form with no information. I have the macro set to filter out all records except the ones that match the work order number of the currently selected record on the "Work Order Sub-Form". Even if I enter the record I want on the pop-up window, the "Details Form" comes up blank, like it's stuck in data entry mode.
Any ideas? Need clarification?