This should be easy but I can’t figure it out. I have a form that displays one row of a table. There are multivalued fields in the form and they are set to a RowSource sql query. Here is the query:
<code>SELECT L4Process.ID, L4Process.L4Process
FROM L3Process2 INNER JOIN L4Process ON L4Process.ID = L3Process2.L4ProcessStep.Value
WHERE L3Process2.ID=2;
</code>
<code>SELECT L4Process.ID, L4Process.L4Process
FROM L3Process2 INNER JOIN L4Process ON L4Process.ID = L3Process2.L4ProcessStep.Value
WHERE L3Process2.ID=2;
</code>
SELECT L4Process.ID, L4Process.L4Process
FROM L3Process2 INNER JOIN L4Process ON L4Process.ID = L3Process2.L4ProcessStep.Value
WHERE L3Process2.ID=2;
As is it works fine, but when the form opens there is a where condition from the OpenForm command that selects the ID of the row. (in this case L3Process.ID). When I try to use the ID field in that where clause, nothing shows up. This is the query I’m using for that:
<code>SELECT L4Process.ID, L4Process.L4Process
FROM L3Process2 INNER JOIN L4Process ON L4Process.ID = L3Process2.L4ProcessStep.Value
WHERE L3Process2.ID=[Forms]![ProcessSummary]![ID];
</code>
<code>SELECT L4Process.ID, L4Process.L4Process
FROM L3Process2 INNER JOIN L4Process ON L4Process.ID = L3Process2.L4ProcessStep.Value
WHERE L3Process2.ID=[Forms]![ProcessSummary]![ID];
</code>
SELECT L4Process.ID, L4Process.L4Process
FROM L3Process2 INNER JOIN L4Process ON L4Process.ID = L3Process2.L4ProcessStep.Value
WHERE L3Process2.ID=[Forms]![ProcessSummary]![ID];
The ID reference is to a text field as the first row in the form. It seems like it should work, is another way to reference the ID that is passed in?