Z
Zoltar54
I have a subform with two combioboxes. The first box "ActRegID' contains a
list of items. Once a seldction is made the second box "LegislationID" is
supposed to display only those items that refer to the ActRegID box.
This works fine when I use the Subform by itself, however when I try to use
the subfor from the Parent, I am asked to enter the criteria. Below is the
query that i have entered into the "RowSource" property of the LegislationID
field:
SELECT Legislation.LegislationID, Legislation.Section, Legislation.ActRegID
FROM Legislation WHERE
(((Legislation.ActRegID)=forms!WarningSubForm!ActRegID));
Can somebody please tell me what I am doing wrong?
Z
list of items. Once a seldction is made the second box "LegislationID" is
supposed to display only those items that refer to the ActRegID box.
This works fine when I use the Subform by itself, however when I try to use
the subfor from the Parent, I am asked to enter the criteria. Below is the
query that i have entered into the "RowSource" property of the LegislationID
field:
SELECT Legislation.LegislationID, Legislation.Section, Legislation.ActRegID
FROM Legislation WHERE
(((Legislation.ActRegID)=forms!WarningSubForm!ActRegID));
Can somebody please tell me what I am doing wrong?
Z