Store List Box values

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Jared
    #1

    Store List Box values

    Store List Box values

    I have a form that has hundreds of records in it. The form has a list
    box with 10 different options in it. The user is able to select
    multiple options from the list box. What I need to figure out is, how
    do I store the options the user selected so when they go to the next
    record the value isn't lost. Can anyone help?
    Tags: None
    • ALESSANDRO Baraldi
      #2
      Re: Store List Box values

      "Jared" <jmgriep@hotmai l.com> ha scritto nel messaggio
      news:9646e57d.0 408161331.51c7b a3d@posting.goo gle.com...[color=blue]
      > Store List Box values
      >
      > I have a form that has hundreds of records in it. The form has a list
      > box with 10 different options in it. The user is able to select
      > multiple options from the list box. What I need to figure out is, how
      > do I store the options the user selected so when they go to the next
      > record the value isn't lost. Can anyone help?[/color]


      I think you can use this way:

      Property DefaultValue As String
      Member of Access.ListBox

      So on AfterUpdate ListBox you can set:

      Me.lstName.Defa ultValue="""" & Me.lstName & """"

      Bye.
      --
      @Alex (Alessandro Baraldi)
      ---------------------------------------------------------------------------
      HTML Redirection Example
      http://www.mantuanet.it/alessandro.baraldi/

      ---------------------------------------------------------------------------


        Comment

        • Pieter Linden
          #3
          Re: Store List Box values

          jmgriep@hotmail .com (Jared) wrote in message news:<9646e57d. 0408161331.51c7 ba3d@posting.go ogle.com>...[color=blue]
          > Store List Box values
          >
          > I have a form that has hundreds of records in it. The form has a list
          > box with 10 different options in it. The user is able to select
          > multiple options from the list box. What I need to figure out is, how
          > do I store the options the user selected so when they go to the next
          > record the value isn't lost. Can anyone help?[/color]


          Loop through the ItemsSelected collection and write them somewhere
          before doing anything else?

          There's code here to grab the contents of the ItemsSelected
          collection:
          Forms: Use Multi-Select List boxes as query parameters
          http://www.mvps.org/access/forms/frm0007.htm

            Comment

            Previous template Next
            Working...