LEE hepworth
Registered User.
- Local time
- Today, 13:42
- Joined
- Nov 14, 2003
- Messages
- 23
Hello
My prob relates to a combo box. I have a form that is linked to a query with which the query consist of employee and then a sales table one to many. Right the users firstly goes to the combo box click on a user or adds the user id which is distinct tabs away and this populates 3 other text boxes..
Everything works well there. Have A select distinct row Employee in the row source Table / Query etc...
The prob relates to when I have a new Employee I enter the details in Employee table but whatever reason I have to add tte same details in another table called employee one. If I do not when the user clicks on this new user the error cannot be taken to end of recordset appears but if its and old id in both tables there is no prob Have tried to delete the employee one table but when a new user is added again the same error appears
have the tables in a back end
Please Help
My prob relates to a combo box. I have a form that is linked to a query with which the query consist of employee and then a sales table one to many. Right the users firstly goes to the combo box click on a user or adds the user id which is distinct tabs away and this populates 3 other text boxes..
Everything works well there. Have A select distinct row Employee in the row source Table / Query etc...
The prob relates to when I have a new Employee I enter the details in Employee table but whatever reason I have to add tte same details in another table called employee one. If I do not when the user clicks on this new user the error cannot be taken to end of recordset appears but if its and old id in both tables there is no prob Have tried to delete the employee one table but when a new user is added again the same error appears
have the tables in a back end
Please Help