search in fromA and display their values in another form vba

pass the search string (employee id) to another form.
Suppose you have forms Form1 and Form2. You want to navigate from form1 to form2.
Do it like this,on the button click event on form one,

Form2 objForm2= new Form2(EmpID)
this.Close();
objForm2.Show();

-------------------------------------------

Now, on Form2, you can override the default form constructor method as

public Form2(String EmpID)
{
//You have got the EmpID here, fetch the data from database and display it.
}


Hope this helps. Please accept answer if it does help or revert back for any queries.

Anurag