Need help understanding listbox and textbox connection.

[WallyZ]

I inherited a simple unbound form that contains 4 textboxs and 1 listbox on it.



The textboxs all have their after update event Embedded macro set to Requery the listbox.

The listbox has a static sql select statement in the recordsource. There appears to be no filter criteria in this record source.

The names of the textboxs do not correspond to the columns in the sql statement. As an example textbox 1 is called ProductNoTxt. Column 1 in the sql is "[Product Number]". Close but no cigar.

When I enter a value in one of the textboxs it filters the listbox correctly on the values I enter.

So my questions are:

How does the listbox get its sql filter criteria from the textboxs?
What links them together?

[cyanidem]

I'm afraid we can't guess what's going on without seeing the form and code.

[WallyZ]

Worked it out in the end.

That sql statement wasn't as static as i thought. It was selecting columns from a query and it was in the the query that the criteria was linked to the forms controls!

Learn something everyday!