Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2002
    Posts
    21

    Unanswered: Populating a ListBox

    Has anyone populated a ListBox using a "user-defined function" as described in the Access help index (RowSourceType, RowSource Properties)? Can anyone point me to a functioning demo of this?

    tia,

    flynn

  2. #2
    Join Date
    Nov 2001
    Posts
    336

  3. #3
    Join Date
    Sep 2002
    Posts
    21
    When I insert the function (as a test) from the link, I get this message (which is basically the same message I get when using my function):

    fListFill my not be a valid setting for the RowSourceType property, or there was a compile error in the function.

    Do you know what the RowSourceType property is set to? I am setting it to the function name (fListFill). But I am not sure how to enter the parameters that the function needs.

  4. #4
    Join Date
    Sep 2002
    Posts
    21
    I think the solution is to put the user-defined function in a module instead of in the code for the form.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •