Add New Value to combo box

[ittechguy]

I have several combo boxes which have 2-3 columns. They all get their row source from a query. First field is the ID, second field is the name. The first column is not visible, so you only see the name.



I'm wondering, is it possible to have a value in the combo box say something like "Add new Organization" and then if that is selected a popup form would popup to allow the user to add a new organization??

[June7]

It would be easier to have a command button next to the combobox.

Including that phrase as item in combobox list would require a UNION query.