Missing Something for Cascading?

[cp1981]

Probably going to get ridiculed for posting this.

I Open my form, click on the combo, list drops, i select, I have nothing in the listbox.

Initially, the list shows up. Once I click on what I select, the list disappears. The combo selection remains in the box.

Query- qryAcctEquip
Form- frmNewServiceCalls
Combo- cboAccountName (Unbound)
List- lstEquipmentName (Unbound)
Hidden Text Box- txtEquipment (Unbound)

ListBox RowSource



Event for ComboBox



ComboBox RowSource


Query SQL






Hidden Textbox Code


I'm at a loss. What's aggravating is I virtually have the same set up for another combo/listbox filter. Only in the "AfterUpdate" event for the combo, it comes from a table and not a query.
Wheres my problem?

[Welshgasman]

You say the combo is called cboAccountName but you use cboAccount for the listbox?
I tend to put SQL code into a string variable so then I can debug.print it to make sure it is correct, then use where needed.

[Micron]

You don't have an operator in the event code, like AccountName =
or whatever it should be.

[davegri]

Deleted. not on point.