How to Add Items to a Combo Box with RowSourceType of Value

MORE INFORMATION

Step-by-Step Example

1. Open the Forms Designer, and place a combo box and text box on the form.
2. With the combo box selected, click the Data tab in the Properties window. Set the RowSourceType property to Value (1), and set the RowSource Property to:

   Choice1,Choice2

3. Click the Methods tab, double-click the LostFocus event, and place the following code in the LostFocus event:

      IF NOT(This.DisplayValue$This.RowSource)
         This.RowSource = This.RowSource + "," + This.DisplayValue
      ENDIF
   						

4. Run the form.
5. In the combo box, type Choice3 and press ENTER. Choice3 should now be part of the list.

There are two important notes about this example. The first is that the item will only exist in the list as long as the form is running. Once you quit the form, the item will be removed from the list. The second is that there is a 255-characters limit to the length of the string that makes up the RowSource.