hi
i'm sure this will not be a new problem, but i need help as i'm not that expert, yet.
i have made a database for my wife to enter her recipes. two main tables, one containing details and other categories.
i have made a form which shows selected recipes depending on categories from combo box selection (select a category and it displays a filtered list of available recipes in that category). then i have placed a button to view the details of selected recipe. working fine, you select a category it will display available recipes and then you click on the recipes to see details.
but after coming through this filter, if i want to move to next record or previous record it just displays the next record, not from the same category.
what i want that when i select a recipe and view it, only the recipes from the category selected can be viewed, not all.
i hope i make myself clear,,
secondly i want to put a 'all category' in combo box so that i can display back all recipes
any help will be appreciated
i'm sure this will not be a new problem, but i need help as i'm not that expert, yet.
i have made a database for my wife to enter her recipes. two main tables, one containing details and other categories.
i have made a form which shows selected recipes depending on categories from combo box selection (select a category and it displays a filtered list of available recipes in that category). then i have placed a button to view the details of selected recipe. working fine, you select a category it will display available recipes and then you click on the recipes to see details.
but after coming through this filter, if i want to move to next record or previous record it just displays the next record, not from the same category.
what i want that when i select a recipe and view it, only the recipes from the category selected can be viewed, not all.
i hope i make myself clear,,
secondly i want to put a 'all category' in combo box so that i can display back all recipes
any help will be appreciated
