Add New option in combo box drop down choices

[Joe Williams]

How can I have a combo box display a list of choices from a table, where the
first entry of the combo box is "Add New" which when selected would open up
the entry form for that table so the user could add a new value? For
instance, A combo box of clients would list the following values:

Add New
Anderson, Kenneth
Beamer, John
Carlson, Charles

etc.

Similar to not In List but a little bit of a twist. Can it be done?

Thanks

Joe

 

[Douglas J. Steele]

Base the combo on a Union query that has "Add New" as the first element.

In the AfterUpdate event of the combobox, check if they've selected that
element, and take the appropriate action if they have.