Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Melbourne, Australia
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    making changes to listboxes (Access 2000)

    Hi Everyone,

    Any ideas, I have a list box on a form. List box and I types in the values, I type 4 values, store the values in the particular field. The
    first time I did it everything was ok.
    However, when I recreate the list box and add 2 more values, assign it to the same field, delete the original list box, and go to form view
    and try and select values from the new list box, it either doesn't display the new values or
    it will no longer store the value in the choosen field.

    Do I have to do some sort of update??

    Thanks Kindly,

    Kerrie [img]/forums/images/smilies/smile.gif[/img]

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: making changes to listboxes (Access 2000)

    I don't understand what you are doing. How are you typing in values into a listbox and saving them into a field? I thought at first you were talking about create a value list as the rowsource for the listbox, but the "saving them to a field" confused me.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: making changes to listboxes (Access 2000)

    Is this a multiselect listbox? Like Mark, I don't understand the bit about typing in 4 values unless you're talking about adding values to a value list, which doesn't require creating a new listbox. What was the point of creating a new one? <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

    If the listbox is bound to the same field as its predecessor, there isn't any reason I can think of for it not to work unless you put something in the wrong place. The controlsource of the listbox should be the name of the field it's bound to, nothing else (no "=" or anything), and the rowsource should be the value list or query or table where the list of values comes from. What are you typing in and what kind of message are you getting when you try to select a value?
    Charlotte

  4. #4
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Melbourne, Australia
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: making changes to listboxes (Access 2000)

    Hi Charlotte,

    I think I have a problem with the way I have created and linked the tables.
    I have sent your a sample from a previous posting.

    Thank Kerrie [img]/forums/images/smilies/smile.gif[/img]

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: making changes to listboxes (Access 2000)

    <hr>I have sent your a sample from a previous posting.<hr>
    Were you trying to post an attachment or did you mean you emailed me something? You should always post attachments rather than emailing unless the zipped files are too large. Otherwise, parts of the question and answer information winds up being unavailable to other loungers with similar questions. If you already posted a sample in another thread, you can post a reference to that post rather than attaching the same file again.
    Charlotte

Posting Permissions

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