Data report Wizards in 'ere!

Hi Peeps!!

Can someone help us out a lil bit ;)

ok, i have a data report, and i want to create data reports with a layout of one customer per page, with their details surrounding it!

Ok, on my main form i have a customerID.text box, and the surrounding ADODCs are controlled by this..... what i want to do is have a report which ONLY shows the report for that specific customer, again just relating to the customerID entered in the text box.....


Anyone know how to do this or at least can point me in the direction???

Ive been racking my brains on the SQL trying to do it, but am not that confident at SQL to be sure if im doing it right, or even in the right place!!

Any help is apprectiated, thanks peeps :)

The SQL to return a single customer based on his CustomerID would be

SELECT * FROM Customers WHERE CustomerID = 'His/HerID'