View Single Post
Old July 26th, 2006, 07:10 AM
sparsh2010 sparsh2010 is offline
Registered User
Join Date: Jul 2006
Location: hyderabad, andhra pradesh, India.
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to sparsh2010

 hello Greg Serrano

    I figured out the problem now the problem is solved , i have just changed the method of invoking form2 by form 1

previously it was

    If (iReply = vbYes) Then
       Form_Form2.Visible = True
    End If

Now it is

    If (iReply = vbYes) Then
       DoCmd.OpenForm "Form2"
    End If

SQL query is same as

SELECT employeedb.ID, employeedb.Fstname, employeedb.LStname, employeedb.Number, employeedb.Address
FROM employeedb
WHERE (employeedb.ID=forms!form2!combo0);

and its working fine

Thanks and Regards