Combobox working on 1 form not on another

[Chillendw]

So I'm a bit baffled and hoping that I can get some help.

Issue is that I'm able to get cascading comboboxes to work in 1 form but not on another, despite using the same vb.

After selecting a Factor (name), only the Lot Numbers associated with that Factor name should show up.

I've attached pictures to show how it works on 1 but not another; it just comes up blank. I've also attached the actual db.

I'm not sure what I'm doing incorrectly. I could just be overlooking something obvious since I've been staring at it for hours.

Thanks in advance.

 

[Jamaluddin Jamal]

It looks like an issue with combo box record source, check out this my solved issue about combo box record source.

 

[pbaldy]

You need a space after LotNumber:

cboLotNumber.RowSource = "SELECT LotNumber " & _

 

[Chillendw]

You need a space after LotNumber:

cboLotNumber.RowSource = "SELECT LotNumber " & _

... Wow... :banghead:
Thanks!

 

[pbaldy]

Happy to help!