Frank, you'da man! What you suggested works, but
, it defeats the purpose of the combo box. Let me explain, there are 4 fields being displayed, I have ordered them (via a query) such that the 'key field' is in column 4 because it is not important for USER to see, she needs to see in order: department, last name, first name, id number. The form allows edits, adds, deletes and opens on the first row of the query with the id number in the combo box. What I would like the form to do is allow USER to add an new record and use the combo box to select an id number by way of looking at all four fields. Hope this makes sense.
nd Shawn, thanks for your suggestion. I tried that too, but like I explained above the order of the columns is visually important to USER because scrolling through IDs is meaningless to her, she needs to read left to right in the order as listed above. Thanks, if you can think of anything else please lemme know! I'm still werking on it.