Method to query all items from a multiselect=none listbox???

Dear all,
I really need help, can't find anywhere what I need to do. I need to
keep my listbox multiselection set to "none" because of the DblClick
event that opens a form with all the data...but I want my query to list
all items listed in the Form's listbox after search and this without
slecting them...(I can't do it anyway because it is not a valid option)
Until now my query displays only one selected item???

My MultiResearch Form is unbound as well as all its controls
The RowSource of the listbox [lstResults] is a SQL statement

My Query has:
Field: IncID
Table: T_Incidents
Criteria: [Forms]![F_MultiResearch]![lstResults]

but it doesn't work, it returns only one selected item...

Any help will be more than welcome.
Maya

.

Relevant Pages

  • Re: Method to query all items from a multiselect=none listbox???
    ... Doug Steele, Microsoft Access MVP ... I can't select multiple items because when I DblClick on one of them I ... keep my listbox multiselection set to "none" because of the DblClick ... event that opens a form with all the data...but I want my query to list ...
    (microsoft.public.access.formscoding)
  • Re: Method to query all items from a multiselect=none listbox???
    ... I can't select multiple items because when I DblClick on one of them I ... Doug Steele, Microsoft Access MVP ... keep my listbox multiselection set to "none" because of the DblClick ... Until now my query displays only one selected item??? ...
    (microsoft.public.access.formscoding)
  • Re: Sorting listbox contents
    ... Sort list box by column when column is right-clicked ... 'Install call to this code in the Mouse Down event of a listbox. ... Dim iLoop As Integer ... MsgBox "List box must use a query as it's row source" ...
    (microsoft.public.access.modulesdaovba)
  • Re: REPOST: Problem With Listbox Selected Property
    ... The queries are shown below. ... the first query is very simple and the second query is a ... year has not been selected in the lstFY listbox. ... >>> sub procedure. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Help - Cant understand Code
    ... Listbox with MultiSelection used in Query ... I have the sample database in its orignial form. ... The subform doesn't have a SELECT statement however the query it is bound ...
    (microsoft.public.access.forms)