Changing Report

[panatha]

I have created a two table db in Access 97 for a hairdressing Salon. One table has customer info, (Id#, name, adress)the second has visit info (id#, name, despriction of treatment, price).
I want to make a report that the user can enter the id# or name, and get a full report of the customer(name, Id, address, treatment etc)
How do i do this?
Any help will be greatly appreciated

Is it possible to have a pop up menu that will say enter ID# and then the report will execute

 

[RSi2]

make a form where you demand the ID and put the ID as a Filter for your report => you'll have only the ID you wanted