My form is based on a query for a main table with some of the fields being originator, creditBy, and restockby.
The query links the employee table to the main table to create a sort of lookup query so that when the employeeID is set as originator on the beforeinsert event of the form, the employee's name shows up in the originatorname field. Most of you should follow this.
The problem is, after the main record is created and a modification is made to the creditmemo number field, I want to set a value to the creditby field, and have the creditbyname field display the employee name. I've done this a zillion times on many databases, but now on my line of code where the value is passed to the field I get the error:
"Can't assign value to blank field on 'one' side of outer join"
What the $@#& does this mean?
I'm goin bonkers....Please help!
~Charity
The query links the employee table to the main table to create a sort of lookup query so that when the employeeID is set as originator on the beforeinsert event of the form, the employee's name shows up in the originatorname field. Most of you should follow this.
The problem is, after the main record is created and a modification is made to the creditmemo number field, I want to set a value to the creditby field, and have the creditbyname field display the employee name. I've done this a zillion times on many databases, but now on my line of code where the value is passed to the field I get the error:
"Can't assign value to blank field on 'one' side of outer join"
What the $@#& does this mean?
I'm goin bonkers....Please help!
~Charity
