create a combo box that gets its rows from a VB Function

B

Bob Quintal

create a combo box that gets its rows from a VB Function
Click to expand...
Create the function to return a semicolon delimited list:

Public Function makeRowSource() As String
makeRowSource = """John"";""Paul"";""George"";""Peter, Paul and
Mary"""
End Function

Then create the combobox. Set the Row source type to value list.
Somewhere in the form's event code you will set
me.comboNNN.rowsource = makeRowSource

Which event you should use depends on your needs. It could be
Form_Load, On_Current, the After_Update event for some textbox or
the On_Enter event of the combobox.
 
Top