I have a function named MyFunction in a standard module that creates a
semi-colon delimited list. I want to use this list for the value list in a
listbox. I have the row source type property set to Value List. Can I use
the function, MyFunction, as the row source of the listbox? I have tried
=MyFunction and just MyFunction and in each case the listbox shows
=MyFunction or MyFunction like it is the first choice in the listbox rather
than showing the value list.

Thanks,

Scott

No. Use some event (such as the form's Load event) to run code that sets the
RowSorce to your function.

Me.ListBoxName.RowSource = MyFunction()


--

Ken Snell
<MS ACCESS MVP>

"Scott" <smiller (AT) nospam (DOT) please> wrote

Ken,

Found this in the Help file but I can't get it to work ---
3 In the RowSourceType property box, enter the name of the function. Don't
put an equal sign before the function name.
4 Leave the RowSource property box blank.

Any comments?

Scott


"Ken Snell" <kthsneisllis9 (AT) ncoomcastt (DOT) renaetl> wrote

That's referring to a very specific call-back function that can be used.

See
http://msdn.microsoft.com/library/en...Parameters.asp
for details of what that function looks like.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Scott" <smiller (AT) nospam (DOT) please> wrote