How to make an Inputbox for report ?

[ashraf.arafat]

Hi


How to make an Inputbox when open report , put the value or the word in inputbox and the report display records according to the value or word which i put in input box????

Example:
I have one Table :
Car Corp - Car Model
Toyota - Corolla
Toyota - Prius
Nissan - Sunny
Nissan - Altima

I want make a report so when i write Toyota in inputbox then gives me the records :
Toyota - Corolla
Toyota - Prius

And when i write Nissan in inputbox then gives me the records :
Nissan - Sunny
Nissan - Altima

Thanks

[CJ_London]

use a parameter in your query

SELECT *
FROM tblCars
WHERE manufacturer=[Enter Manufactuterer]

[ashraf.arafat]

Sorry I don't understand
Can you make it to my example file in attachments please ???
Thanks
Example.accdbExample.accdb

[CJ_London]

all you have is a table so all I can provide is a query

1.open a new query
2.close the 'Show Table' window
3.click on the sql option top left on the ribbon
4.delete whatever code is there
5.and then copy and paste this code

SELECT *
FROM Table1
WHERE [Car Brand]=[Enter Brand]

in its place

6. click on the run (!) option in the ribbon

[ashraf.arafat]

It works
Thank You