R
Rick
Hi there,
I have 2 combo boxes cboCategory and cboAsset. I want to select a
Category from cboCategory and have the assets that belong to that
category come up in cboAsset. I have tried to follow tips found on
this NG but my list will not populate into cboAsset, the list is
blank.
Here is my RowSource for cboCategory....
SELECT tblCategories.AssetCategoryID, tblCategories.AssetCategory
FROM tblCategories;
AfterUpdate for cboCategory....
Private Sub cboCategory_AfterUpdate()
Me![cboAsset].Requery
End Sub
Here is my RowSource for cboAsset....
SELECT qryAssets.AssetCategory, qryAssets.AssetDescription
FROM qryAssets
WHERE (((qryAssets.AssetCategory)=[forms]![frmAssets]![cboCategory]));
Can someone please help me sort this out, any help is appreciated.
Rick Ashton.
I have 2 combo boxes cboCategory and cboAsset. I want to select a
Category from cboCategory and have the assets that belong to that
category come up in cboAsset. I have tried to follow tips found on
this NG but my list will not populate into cboAsset, the list is
blank.
Here is my RowSource for cboCategory....
SELECT tblCategories.AssetCategoryID, tblCategories.AssetCategory
FROM tblCategories;
AfterUpdate for cboCategory....
Private Sub cboCategory_AfterUpdate()
Me![cboAsset].Requery
End Sub
Here is my RowSource for cboAsset....
SELECT qryAssets.AssetCategory, qryAssets.AssetDescription
FROM qryAssets
WHERE (((qryAssets.AssetCategory)=[forms]![frmAssets]![cboCategory]));
Can someone please help me sort this out, any help is appreciated.
Rick Ashton.