using a field in a form or report to search for a specific record.

[MDBURDEN1954]

I am creating an Access 2016 database to assist in the management of a large amount of Recipes.



I have created a report that displays all recipes sorted by Food Category
Basically the report gives the Food Category and recipe name followed by a button that will open the full Recipe like

Category
Recipe Name Display Recipe Button
Recipe Name Display Recipe Button
Recipe Name Display Recipe Button

Category
Recipe Name Display Recipe Button
Recipe Name Display Recipe Button
Recipe Name Display Recipe Button

Category
Recipe Name Display Recipe Button
Recipe Name Display Recipe Button
Recipe Name Display Recipe Button

How can I program the Find Recipe Button to go to the Recipes Table, Find the recipe using the Recipe name on that line of the query, and display in a form?

I have tired and can only get the first record of the Recipe Table to show?

[Micron]

First, you should drive the opening of the report from a form, displaying all (as you seem to be doing now) or just one (based on the contents of one form textbox or combo box) which is kind of what you're asking about - except for not doing it off of a report. While it's possible, would you drive home a nail with a shoe? At least, that's what it seems you're trying do do

I have created a report

yet you also say

Find the recipe using the Recipe name on that line of the query

so it's not clear.

Start with a query that works and post back after clearing things up. If you want to be able to open the report or a form listing recipes that match more than one criteria (more than one recipe name) then you will need a listbox. Your query will need a LIKE operator if you want any recipe that may contain the keyword in its name (such as 'Blueberry Pie' AND 'Blueberry Cheesecake').

[davegri]

Trying to replicate what you are showing, I would create a form with a combobox and a listbox.
The combobox would allow you to select a Category, then all the recipes in that category would appear in the listbox.
Double Clicking on a listbox recipe would open a form showing that recipe details.