Refresh a query to fill in a combo box

[Jimjr]

I have an update subform with 3 fields per row - "Trust", the category the Trust belongs to, and the "queues" available for that category. The user can add, chg or delete rows.


There's about 30 Trusts, each belongs to 1 of 3 categories. Each category is allowed 4 or 5 "queues" specific to the category.


The "Trust" is selected from a combo drop-down list from a table. The category is in a text box comes from the same table and is locked.


I want the drop-down for the queues to comes from a query -

 SELECT [Queues list].Queue, [Queues list].Category
FROM [Queues list]
WHERE ((([Queues list].Category)=[Forms]![Update Trust Reviewers]![Reviewers Trusts table subform]![category]));

It works correctly on the first row, but the combo box of queues does not change if the next row has a Trust in a different category. so I need to refresh the query somehow when the user clicks the next line. Somehow specifying the row being clicked?

TIA

[June7]

In form Current event and/or combobox GotFocus.

Me.MyCombobox.Requery

Review https://stackoverflow.com/questions/...t-show-its-val