I have a combo box (MasterSNcbo) that lists a bunch of parts based on a Table (PartBOMT).
Ex.
PartBOMT table looks something like this:
MasterPN, EngineeringPN, Used
BOM1 Part1 Yes
BOM1 Part2 Yes
BOM1 Part3 Yes
BOM2 Part1 Yes
BOM3 Part2 Yes
When a MasterPN is selected in the combo box (MasterSNcbo), the list box (List3) should update the list of EngineeringPNs based on the query in the list box row source.
Below is the row source sql:
SELECT PartBOMT.MasterPN, PartBOMT.Used, PartBOMT.EngineeringPN
FROM PartBOMT
WHERE (((PartBOMT.MasterPN)=Forms!Tools4F!MasterSNcbo) And ((PartBOMT.Used)=True));
The List3 listbox is not updating though when a part is selected.
I don't know the reason why.
Note: If I hard code the MasterSNcbo part number in the listbox query (="BOM1") it works but if I use (Forms!Tools4F!MasterSNcbo) it don't.
Why?