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

subform recipe
Recipe Number Ingredients Quantity
      2 Eggs 2
      2 Flour 4
      2 Milk 5
      2 Sugar 2


Thanks any help would be appreciated

jd erd

__________________
jd erd

This is an interesting issue. I might add criteria to the query like this:

Recipe Number:
[Forms]![frmYourMainForm].[cboRecipe]

See if that works. It may not since when the form opens, no recipe is selected. A kludge would be to create a blank recipe with Recipe Number 0, and then make that the default selection on the combo box.

Is that working?

mmcdonal

I was thinking as for now just making the sub form invisible until a recipe is selected from the combo box and the second problem I have is when the recipe is selected I want it to be editable on the sub form

jd erd

I tried your suggestion but my problem is it is not allowing me to add items to the recipe from the product table such as for example butter. I want to be able to add items to the recipe from a products table by using a combo box in the recipe table.

jd erd