Is there any way to add values to a Combo Box Value List from the open form, not adding values in RowSource in design mode. I know this can be done if the values for your combo box are coming from a table. I am just curious, can the NotInList property be used to add to a list not a table. Thanks for your help.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Adding Values to Combo Box Value Lists
- Thread starter wfweirich
- Start date
Hi!
In the NotInList event use the following to add to a Value List:
Me!YourComboBox.RowSource = Me!YourComboBox.RowSource & ";" & NewData
Of course, you will want to ask the user if the data they entered is correct so you don't add an error to the value list.
hth
Jeff Bridgham
bridgham@purdue.edu
In the NotInList event use the following to add to a Value List:
Me!YourComboBox.RowSource = Me!YourComboBox.RowSource & ";" & NewData
Of course, you will want to ask the user if the data they entered is correct so you don't add an error to the value list.
hth
Jeff Bridgham
bridgham@purdue.edu
- Status
Similar threads
- Locked
- Question
- Locked
- Question
