Hi..

I have a table: PROFESSOR in ms access, that has 2 fields: "Name" and "Location". The table has 10 records.
And i have made a vb form with a combo box that will show a list of available locations from the database table, when it is dropped down.

So, the end user will select a location from the cbo on the form and i want that to be used as the basis of the report to be generated.

QUESTION:
========
1. How do i pass the value (i.e the location selected by the user) to the report designed ?

2. If i want the report to be generated based on the user's selection of "Location", then do i use the standard wizard which is popped up when the Crystal Report 11 designer module is added from the project exploere in vb6 ??

Pls answer the questions in order of them stated above.
Help will be surely appreciated...

----
Regards,
Gautam Naidu