Combo box trying to add names

[FacilitiesCAD]

How do I make a combo box so I can add more inputs over time from the same form.

For example I have a form with a combo box that lists persons names. If I want to put a different persons name in than is on the list I just type it in. This doesn't end up adding her name to the list. Ist there an easy way to do this?


Tim

 

[Nowell]

Hi,
Is the combo box getting its data from a table? if so juast create a form related to that table and have a command button to open the form and add new name.

 

[FacilitiesCAD]

Yes, The combo box is getting the information from a table.
I saw the "On not in list" I just dont know how to code it to add to list at that point. I would prefer to have an event procedure that atomatically adds it to the list.

something like
sub not on list
append me.people to table(names)
end sub

obviosly this isn't the right code but I hope it shows my intents so someone can show me the right code.

Tim

 

[Nowell]

Hi,

I use the OnNotInList statement and I just have it opening a form related to that table, so the user can add the new data.