P
Peter Kinsman
I am having big problems with a subform to create Bill of Materials records.
The first combo box
selects the Type and the other selects the Item Description - whose
RowSource is controlled by the
Type combobox. The RowSource is set to one of two queries:
qryAllDescriptions
SELECT tblCodes.Rec_ID, tblCodes.Description,
tblCodes.OrigCode AS Recipe, tblTypes.Short
FROM tblCodes INNER JOIN tblTypes ON tblCodes.MType = tblTypes.Type
ORDER BY tblCodes.Description;
qryFilteredDescriptions
SELECT tblCodes.Rec_ID, tblCodes.Description,
tblCodes.OrigCode AS Recipe, tblTypes.Short
FROM tblCodes INNER JOIN tblTypes ON tblCodes.MType = tblTypes.Type
WHERE
(((tblTypes.Short)=[Forms]![frmUpdateProduct]![sfrmUpdateProduct].[Form]![cboType]))
ORDER BY tblCodes.Description;
With the RowSource set initially to qryAllDescriptions, existing records
appear correctly, but as soon as
I select the Type for a new record, it applies the filter to all the
Descriptions on the subform.
Hopefully during the refresh of the subform there will be an event when I
can set the appropriate RowSource,
but does anyone know what it is please?
Many thanks
Peter Kinsman
The first combo box
selects the Type and the other selects the Item Description - whose
RowSource is controlled by the
Type combobox. The RowSource is set to one of two queries:
qryAllDescriptions
SELECT tblCodes.Rec_ID, tblCodes.Description,
tblCodes.OrigCode AS Recipe, tblTypes.Short
FROM tblCodes INNER JOIN tblTypes ON tblCodes.MType = tblTypes.Type
ORDER BY tblCodes.Description;
qryFilteredDescriptions
SELECT tblCodes.Rec_ID, tblCodes.Description,
tblCodes.OrigCode AS Recipe, tblTypes.Short
FROM tblCodes INNER JOIN tblTypes ON tblCodes.MType = tblTypes.Type
WHERE
(((tblTypes.Short)=[Forms]![frmUpdateProduct]![sfrmUpdateProduct].[Form]![cboType]))
ORDER BY tblCodes.Description;
With the RowSource set initially to qryAllDescriptions, existing records
appear correctly, but as soon as
I select the Type for a new record, it applies the filter to all the
Descriptions on the subform.
Hopefully during the refresh of the subform there will be an event when I
can set the appropriate RowSource,
but does anyone know what it is please?
Many thanks
Peter Kinsman