I am having excel data and designed a form using EXCEL VBA. each record of the excel is represented with a number. I will call the data onto the userform using the particular number. When I connected the excel data to my crystal reports 9, all the records are coming onto the report form. But I want to call only a particular record from excel. What would be the solution for this ?

No sir, Assume a record consists of emp ID, empname, design, DoB,DOJ, salary etc., Here Emp ID will play vital role as it acts as a primary key. Like that I want to call on to the CR a particular record by calling emp ID. Pls tell How could it possible ?