I want to populate a user array with abbreviations that either match the full info found in ListBox column 1 or the abbreviation found in column 2 or have the user enter his/her own abbreviation in ListBox column 3. Each row in column three must not be empty.
-
-
If the user has made no selection when you refer to a column in a combo box or list box, the Column property setting will be Null. You can use the IsNull function to determine if a selection has been made, as in the following example.
If IsNull(Forms!Cu stomers!Country )
Then MsgBox "No selection."
End If
Comment