Forcing user to Enter data in 2 forms.

I am doing a project on payroll system with vb & access.

I am using 2 vb forms

1. frmEmp connected to emp table

2 frmSal connected to salary table.

In the emp table i am storing all the personal details of the employees which donot change every year.

Where as salary table is revised every year as the revision of salary takes place.

So i am storing the data as per the accounting year in the salary table so that I will be able to find out what was the basic salary of a particular employee in any one of the previous year

Due to this i am managing the data separately in 2 table & inputting the same using 2 forms.

When a revision of salary takes place the user ( Person incharge of making payroll ) is able to open the salary form & enter the revised figures for the new accounting
year.

(I am using a combo box in frmSal which selects the employee number of the employee whoes record exist in the emp table. So technically the salary record of the employee can be entered only after his personal details are entered in emp form & saved)

However when a new employee joins the company, the user inputs the data in frmEmp form but he is able to come out of frmEmp form & thus he may forget to enter the data ( ie the salary details of the new employee ) in frmSal ( Salary form ).

I want to force the user to enter data in both the forms( frmEmp & frmSal) when a new employee joins the company.

Please guide me as to how to tackle this problem.

Thanking you,
Dennis.

Check the value of salary in the close event of your first form if it equals zero then prompt the user to enter the information.

Do you automatically create a new record in the salary table when a new employee is created? I would it will make it easier to verify if the salary has been entered or not. You could have both forms displayed at the same time if the salary form was a child form of the employee form.

HTH


JFK