Results 1 to 5 of 5

Thread: lsit box - database

  1. #1

    Thread Starter
    Fanatic Member joltremari's Avatar
    Join Date
    Sep 2000
    Location
    Mississippi
    Posts
    674
    How can I populate a list box with the info from a database field.

    Thanks

    JO

  2. #2
    _______ HeSaidJoe's Avatar
    Join Date
    Jun 1999
    Location
    Canada
    Posts
    3,946

    <?>

    Assuming you know how to open a database and set your data controls.

    While Not Data1.Recordset.EOF
    List1.Additem Data1.Recordset!databaseFieldName
    Data1.Recordset.MoveNext
    Wend

    then close up shop and be on about your business
    "A myth is not the succession of individual images,
    but an integerated meaningful entity,
    reflecting a distinct aspect of the real world."

    ___ Adolf Jensen

  3. #3

    Thread Starter
    Fanatic Member joltremari's Avatar
    Join Date
    Sep 2000
    Location
    Mississippi
    Posts
    674

    Re: <?>

    Thanks-a-bunch

    I get an error when I put that in the Form_Load event but it works with a Command_Click. Any ideas on how to use this in the Form_Load event

  4. #4
    Frenzied Member Jop's Avatar
    Join Date
    Mar 2000
    Location
    Amsterdam, the Netherlands
    Posts
    1,986
    Try it in Form_Activate
    Jop - validweb.nl

    Alcohol doesn't solve any problems, but then again, neither does milk.

  5. #5

    Thread Starter
    Fanatic Member joltremari's Avatar
    Join Date
    Sep 2000
    Location
    Mississippi
    Posts
    674
    That works, I appreciate it

    JO

Posting Permissions

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



Click Here to Expand Forum to Full Width