Results 1 to 2 of 2
  1. #1
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: The Last Hurdle! (XL2000 SR-1)

    Tricky

    <<< I don't know how to initialize the values on the USERFORM where a combo / list box is involved?? >>>

    OK so I imagine that the user has done some work and this work is stored in a database. You retrieve it by some sort of an index and the item that was stored from the before needs to be selected in the ListBox. So you can
    1) Store the ListIndex with the Item selected. Best approach
    2) Find the ListIndex and display the item for that index. Way too much work.

    If you need help coding the above let us know.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    The Last Hurdle! (XL2000 SR-1)

    <P ID="edit" class=small>Edited by gwhitfield on 01-Dec-01 13:34.</P>This post was cross-posted <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=vb&Number=97046&page=0& view=expanded&sb=5&o=&fpart=&vc=1#Post97046>here</A>

    With help from many on this forum, I have almost finished my project - just one more hurdle to jump.

    My example includes a database that is filled by the user via a USERFORM. A date is selected, a few entries are made and the information is stored in a database.

    When the user selects a date for editing and data already exists for that date, then the USERFORM should be populated by those previous entries.

    I don't know how to initialize the values on the USERFORM where a combo / list box is involved??

    Please take a look at the example and any advice would be appreciated.
    Attached Files Attached Files
    - Ricky

Posting Permissions

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