I would greatly appreciate some help on this problem
I have main form that is unbound and has information loaded into it from a dataset and then a filter is applied to to a combo box. Anyways when I select an item from the unbound combo box I want it to filter a sub form that is bound to a query and displayed in datasheet view.
example: when I select a recipe number from the combo box it filters the subform to that recipe.
cborecipe: 2 cake
Recipe Number Ingredients Quantity
2 Eggs 2
2 Flour 4
2 Milk 5
2 Sugar 2
Thanks any help would be appreciated