Windows XP 
Access 2007
I have a form that allows the end user to either edit employee information or add new employees. In this form are two subforms. One subform contains employee information and works just fine. The main form contains Human Resource information and works just fine. The second subform contains information from the department table.
When I enter a new record in this form and put some information into the form it automatically creates a new record in my employee subform and fills in the employeeID (which is an autonumber). It also creates a new record in my Department Table subform. (This subform is based on a query that joins the department and the department table based on DeptID). (So far so good)
Now the issues begin
If I put in a DepartID in right away, then everything works fine; however, I have set this up for the end user to put in the Department Name (since no one actually knows that numbers off hand). Once they put the Department Name in, then the DeptID becomes non-typable. I have no idea why. If I click out of the subform is tells me it can't find a record in the table Department with key matching field(s) DepartmentID. What I would like is for them to select Department (This is a dropdown which was created automatically when I brought in the subform) and have DeptID fill in.
Thank you in advanced for any help you can give.
Reply With Quote
