D
dustinw101
I hope I can explain my problem well enough:
I have my main form (which is linked to the main table) with one of the combo
box fields called 'salesperson'. The user has to select a sales person from
the combo picklist, however, that pick list is populated based on an
employee_roster table. In the employee roster table I have the fields (ID,
First Name, Last Name, Active(Text Field Lookup with values limited to
"Active" & "Terminated")). I do have the source query of the combo box in
the main form written to only select 'Active" employees. My problem is that
if the user creates a main record and selects sales person "A" with ID '1' (I
save only the employee ID into the main forms table) and then the employee
gets terminated....when I go into the main record, the combo box will not
populate the field with the name of the terminated employee. When I write in
some debug code to view the value of the combo box it does show the employee
number but will not display the name. Any suggestions on how I can go about
getting names to show from previous entries even when the employee has been
marked terminated?
I have my main form (which is linked to the main table) with one of the combo
box fields called 'salesperson'. The user has to select a sales person from
the combo picklist, however, that pick list is populated based on an
employee_roster table. In the employee roster table I have the fields (ID,
First Name, Last Name, Active(Text Field Lookup with values limited to
"Active" & "Terminated")). I do have the source query of the combo box in
the main form written to only select 'Active" employees. My problem is that
if the user creates a main record and selects sales person "A" with ID '1' (I
save only the employee ID into the main forms table) and then the employee
gets terminated....when I go into the main record, the combo box will not
populate the field with the name of the terminated employee. When I write in
some debug code to view the value of the combo box it does show the employee
number but will not display the name. Any suggestions on how I can go about
getting names to show from previous entries even when the employee has been
marked terminated?