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

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

=?Utf-8?B?QW5pbA==?= wrote in
news
create a combo box that gets its rows from a VB Function

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.


--
Bob Quintal

PA is y I've altered my email address.
** Posted from http://www.teranews.com **