Add to Combo box on the fly

[Mercy]

Hello,

I posted a similiar question earlier ... but for some
reason I can't see the reply.

Anyway ... I know how to add a value to the Combo box by
typing a new value in...

In my case ... the Combo box is for: Colors
The Table the data comes from has the fields:
Company, Color, ColorID

I can't let the user add a Color w/out adding a Company
and a ColorID.

I want to be able to "Edit" the list... er.. table on the
fly. Ie: Let the user choose "Edit List" from the
list ... which will open the table where the list gets
it's values.

At first I was going to use an input box to get the rest
of the values ... but this way feel slike a never ending
question.

I also tried putting a DoCmd.OpenForm to open the Table
in the "not in list event" ... but that's not working too
well ... What happens is that the Form opens ... and
the "Not in list" event ends ... and Access pops up a msg
saying that: "The value you chose is not in the list." I
can't find anyway to "pause" the procedure so I can enter
values into the Form...

Any Ideas?
Thanks,
Mercy