Query & InputBox

[RemusRigo]

hi guyz



I have a database with customers and i want to use a query that shows customers with a name that i select
Can i use in the query statement a InputBox? I have tryed and I get errors

Can anyone help me?
I ca use a Form/Report/Query as laong as it shows only the customers with the name I input...

Thanks

Regards
Remus Rigo

[rommelgenlight]

if you only want to view your customer in a QUERY then in the criteria of customername field you can put "[Enter CustomerName]" so that when you open that query it will show you an kind of inputbox where you can enter your customername. Or you can study how to use FORMS as where you can enter your value for customername as criteria for your query.