Listbox query from Combobox not working.

[JB510]

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?

[Micron]

Use the after update event of the combo to requery the listbox.

https://learn.microsoft.com/en-us/of...istbox.requery

[JB510]

TY it works now..
I thought it would update automatically..
I entered an After Update in the MasterSNcbo combo box to ..
Forms!Tools4F!List3.Value = Null
Forms!Tools4F!List3.Requery

Thanks.

[Micron]

Glad I could help.