Anyone can help me in VB6 using DAO.
My problem is how to find record/s using different tables.
Example: After saving the data in Form1, I want to shift to form2 thru a command button in form1. When I press the command button to open form2, the code will unload form1 and open form2 using the same reference ID.
Meaning, If I'm working EmployeeID 1 in form1 after saving the data in form1, when I press the cmd buttom for form2 inside form1. The code should unload form1 and load form2with the same EmployeeID that I'm working in form1. Also will show the First Name and Last name of the same EmployeeID in form2.
Fact: The Table in form1 has the following fields: EmployeeID, First Name, Last Name, age, sex and other personal information. While in form2 the fields are EmployeeID and other Employment Information. EmployeeID in table 1 has a relationship in EmployeeID in table 2.
Please help me the code. Thank you.