I have a navigation form and I want to use a control from a different form to pass to a control in the clicked on form of the tab.
Me.L3Processes.RowSource = "SELECT L3Process2.ID, L3Process2.L3Process, DataObjects.ID
FROM DataObjects
INNER JOIN L3Process2 ON DataObjects.ID = L3Process2.DataObjects.Value
WHERE DataObjects.ID = '" & [Forms]!L3Process5![DataObjectsList].Column(2) & "'"
I’m on L3Process5 when I click on the tab with the L3Processes list, I want the selected value in L3Process5.DataObjectsList to go into the query above. The query runs in the Form_Open event of the new form. I get an error that says it can’t find the referenced form L3Process5. Is it because the previous form has already closed?