Hello, I am having a problem with a data entry form. The form is for entering data from employee production logs. In the main form I want to capture the employee name, date, work arrival time and work departure time. I then want to move to the subform to capture detail from the log. Each record in the main form may have multiple records in the subform. I added a command button on the main form to save the Main form record before moving to the subform.
Once data has been entered into the last field of the subform, the cursor moves to a new record on the subform, not back to the Main form. To enter data for another employee, the data entry operator must click on the first field of the Main form and enter a new user name date arrival, departure time.
The problem is that the subform will not allow entry in any of the fields. My query must be set up incorrectly. I have checked Allan Browne's website, on why a query might not updatebut can't find the problem.
I have attached a word doc that might help explain my set up a little better.
Thank you in advance for any insight to my problem. Also, I don't know SQL.
Once data has been entered into the last field of the subform, the cursor moves to a new record on the subform, not back to the Main form. To enter data for another employee, the data entry operator must click on the first field of the Main form and enter a new user name date arrival, departure time.
The problem is that the subform will not allow entry in any of the fields. My query must be set up incorrectly. I have checked Allan Browne's website, on why a query might not updatebut can't find the problem.
I have attached a word doc that might help explain my set up a little better.
Thank you in advance for any insight to my problem. Also, I don't know SQL.