Novice help Please!!!!

[hussainshah]

I am completely new to Microsoft Access but otherwise consider myself to be a Tech Geek. I have made a very simple and small database. It contains the name of my customers and the orders they have placed with my company over the past three years.

Now i want to generate report which when given the name of my customer would give me all the orders placed by that specific customer. I know how it can be done query but i want to do it through some kind of access page so that my subordinate who is very technically challenged can manage that.

Though i know it is a very basic question but i tried everything and could not do it....can somebody please please please help me.!!!!

 

[Smart]

I would create a form with a combo box that selects all the customers names

create a query that selects all the info you require and in the customer column of the query type in the criteria section
forms![yourformname]![yourcomboboxname]

create a report based on your query

add a button next to the combo box on your form and select the report that you have created

chose a customer from the combo box click the button and the report runs