Condition in Form

[samot79]

Hi!

I have a small database with three tables

IngredientTable

ID

Ingredient

Category

RecipeTable

ID

recName

Tables have a many-to-many relationship so I also have a conjunction table.

Ingredient_RecipeTable

IngredID

RecID

Qty

Now I have a form where user may add ingredients to a recipe. Form shows all recipes and all ingredients that have been mapped which starts to get pretty long. I have added a combobox in forms header where user select which recipe he/she wants to edit, add new ingredients to a recipe or change existing ones.

Problem I have now is that only want to show recipe user have select, but cant make this happen. I guess I have to write an SQL statement under events for Combobox?

Help is very much appreciated.

Thanks!

[June7]

Options:

1. intrinsic filter tools on the ribbon or right click filter on bound control - no code required

2. intrinsic Filter by Form method - no code required http://www.keystonelearning.com/reso...ilter_by_form/

3. use UNBOUND combobox to select recipe and VBA to build filter criteria and apply to form Filter property http://www.allenbrowne.com/ser-62.html