Hi,
I have a combo box which gives the initials, first name, and last name of employees. When you select an employee, their initials show up on the form, while their ID number is stored in the underlying table (the ID # is in the first invisible column in the dropdown).
The problem is that on occasion we get samples from outside our organization, in which case I would like to enter NA into this box, or possibly the organization's name. In order to do this, I need to set the 'limit to list' property to no, but Access won't allow me to do this unless I make the first column (Staff ID #) visible, in which case the correct info is still stored on the table, but the initials no longer appear on the form, and all I can see in the form is the ID # (which is annoying).
Is there any way to work around this? Should I just add an employee called 'NA'? Should I create an second text box automatically showing showing the employee name where I can enter NA if necessary? I just realized too, that since the field in the underlying table is a number field, I might not want to put 'NA' in there? How do other folks deal with NAs in their databases?
Any feedback much appreciated!
EJ
I have a combo box which gives the initials, first name, and last name of employees. When you select an employee, their initials show up on the form, while their ID number is stored in the underlying table (the ID # is in the first invisible column in the dropdown).
The problem is that on occasion we get samples from outside our organization, in which case I would like to enter NA into this box, or possibly the organization's name. In order to do this, I need to set the 'limit to list' property to no, but Access won't allow me to do this unless I make the first column (Staff ID #) visible, in which case the correct info is still stored on the table, but the initials no longer appear on the form, and all I can see in the form is the ID # (which is annoying).
Is there any way to work around this? Should I just add an employee called 'NA'? Should I create an second text box automatically showing showing the employee name where I can enter NA if necessary? I just realized too, that since the field in the underlying table is a number field, I might not want to put 'NA' in there? How do other folks deal with NAs in their databases?
Any feedback much appreciated!
EJ
