How to upsize unbound listbox?

[Ian Hinson]

I have a listbox on an "Ingredients" form in a front-end db that I am
converting (form-by-form) to ADP that listss all the Products that use the
current Ingredient on the Ingredients form.
Its rowsource is:
SELECT Product.Name
FROM Product INNER JOIN Formulas
ON Product.ProductID = Formulas.ProductID
WHERE Formulas.IngredientID = Forms![Ingredients]![IngredientID];

In Access, the listbox is requeried (on the Form_Current event) so that it
synchronises with IngredientID of the current record.

What is the ADP workaround for this situation seeing as
"Forms![Ingredients]![IngredientID]" means nothing to the SQL server?

Thanks,
Ian.

 

[Ian Hinson]

Figured out a way...
Construct a new SQL string that includes the criteria, then change the combo
box's RowSource to the new string. No need for a Requery.