I have researched this in the knowledge base and found answers but I am having trouble applying them.
The first goal is to have a Part Name selected in my form and when that is chosen the corresponding part number shows in another combo box.
FYI, this is part one of this question once this works I want to know if you can go both ways. Pick a part number and it populates part name or part name and it populates part number.
So far for Goal 1 there is
frmISParts it has
cboPartsName with row source of:
SELECT [tblPartsList].[plID], [tblPartsList].[plPartName] FROM tblPartsList ORDER BY [plPartName];
AfterUpdate event of:
Private Sub cboPartName_AfterUpdate()
then we have cboPartNo
with a row source of:
SELECT ptPartNumber FROM tbPartsList WHERE ptPartNumber=Forms!frmISParts!cboPartName;
What am I missing to reach my first goal?
Thanks for your help!!