A shove in the right direction?

[timmygrover]

Howdy!

So, here's what I want to do: I want to fill out a form that looks like this (for example)



Fruit: ________ (say we enter apple)
Color: ________ (say we enter red)

and then, I want to have a button that you click and have a subform that runs a query and outputs "red apple"

Obviously, this is a very basic example of what I'm trying to accomplish, and I know how to do this using a table and then a query (so an explanation of concatenation is not needed). What I don't know how to do is have both parts of the process (the initial entry and then the query) exist in the same form. I don't even know where to begin. SO if someone could give me a shove in the right direction, I would really appreciate it.

In attempting this, I've run into the following problems:

1. I have no idea how to make a button that will run a query
2. I have no idea how to restrict the queries results to what I've entered into the form
3. More things I can't think of right now

Again, I realize that I'm being vague, but this is more because I've only got a vague understanding to use as a basis for my questions. Any help that will bring me closer to understanding would be greatly appreciated!

Thanks in advance to all the access wizards who will respond!

[June7]

For parameterized query approach (query would be the RecordSource of form), review tutorials at http://datapigtechnologies.com/AccessMain.htm especially 'Build a Custom Filter in Your Form' and 'Creating a Basic Search Form' in Access Forms: Tips and Techniques section.

[timmygrover]

For parameterized query approach (query would be the RecordSource of form), review tutorials at http://datapigtechnologies.com/AccessMain.htm especially 'Build a Custom Filter in Your Form' and 'Creating a Basic Search Form' in Access Forms: Tips and Techniques section.

Thanks Super Moderator!