'Supervisor' Issue (HELP!!)

[vt800c]

First, this is a great forum and you are batting a thousand on helping me with my issues. but this one is going to be tricky.

I want to make a table entry for a person. Part of the entry is the individual's supervisor. I want to be able to select it from a combo box based on some previously entered data. (that was the cascading combobox issue. you people nailed that one!) However, here is the issue:



If there are no rows returned for the underlying query for the supervisor, I want the ID (Autonumber, Key) field of the person I AM CREATING to be placed in the 'supervisor' field (making the person 'self-managed').

For the purposes of this illistration imagine the table as:
Person_ID, Person_Name, Person_Data, Supervisor_ID

[kennejd]

I guess you could write some after-update code to do this. I would probably leave the field blank and then use an iif function in any associated queries to do the calculation you're looking for.

[vt800c]

Is there a way that I can find out what the key value of the new person is GOING to be (assuming it's the highest autonumber value +1) and plug THAT value into the field when the user clicks the 'save' button (or the save event of the record)?

[vt800c]

Ok...I got my solution. I wasn't quite complete in my problemspace, and realized I was trying to populate the field with an incorrect source value. All better!