Re: list box
From: Wayne Morgan (comprev_gothroughthenewsgroup_at_hotmail.com)
Date: 04/01/04
- Next message: Warwick Hunt: "Controls and Combinations"
- Previous message: anonymous_at_discussions.microsoft.com: "page breaks"
- In reply to: nerd: "list box"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 1 Apr 2004 04:18:01 -0600
The value of the listbox is stored in the Control Source's field. The value
of the listbox is from the Bound Column of the selected row. This is for a
single select listbox. For a multiselect listbox you have to loop through
the ItemsSelected property to get the values for each selected row, these is
no "value" for the listbox itself when using a multiselect listbox. Also,
you shouldn't store multiple values in a field. This makes the data very
difficult to sort through and retrieve later. Instead, you may need multiple
fields, perhaps several Yes/No fields, one for each possible selection.
Multiselect listboxes usually aren't used for "data entry", they are used
for "criteria selection" such as "I want to see the players on the selected
football teams."
-- Wayne Morgan Microsoft Access MVP "nerd" <anonymous@discussions.microsoft.com> wrote in message news:16c9b01c417cc$de994390$a401280a@phx.gbl... > i have a list box that can select multiple values, but it > doesn't store any of them in the desired field in the > table. how do i solve this or get around it?
- Next message: Warwick Hunt: "Controls and Combinations"
- Previous message: anonymous_at_discussions.microsoft.com: "page breaks"
- In reply to: nerd: "list box"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
