Re: Multiselect parameter query

A parameter will only pop up its dialog once.

If you know how many parameters you might need, you could use multiple parameters on the one field - criteria such as:
[Enter first value] Or [Enter another value] Or [Enter a 3rd]

Realistically, it gets stale pretty fast answering each parameter every time. Much better to use a form where the user can use any number of boxes they need, and leave the others blank. You can then set up multiple unbound text boxes such as:
Surname: [ ]
or [ ]
or [ ]
and just itnore the boxes the user leaves blank. Alternatively, you can use a multi-select list box so the user can select multiple values. Ultimately, you create a string to use as the WhereCondition for OpenReport, as the Filter for your form, or even as the SQL of a QueryDef.

For the techniques to build the string on the fly from the controls the where the user entered something, see:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

For an example of the multi-select list box, see:
Use a multi-select list box to filter a report
at:
http://allenbrowne.com/ser-50.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Scott" <NoSpam-Scott.Xe@xxxxxxxxx> wrote in message
news:eegDJ8oOHHA.3900@xxxxxxxxxxxxxxxxxxxxxxx
I need to enter more than one entry for parameter query. Can someone advise me how to accomplish it.

Thanks,

Scott

.

Relevant Pages

  • Multiple Combo Boxes as Criteria for Continuous Form
    ... combo boxes and click command button that will then list some information ... The code for the command button is: ... Private Sub Btn_OpenUpdateList_Click ... form multiple times. ...
    (microsoft.public.access.formscoding)
  • Re: Find multiple words in a memo
    ... I wasn't talking about having multiple text boxes: ... Dim intLoop As Integer ...
    (microsoft.public.access.queries)
  • Re: Text Box Overload?
    ... If you experience this problem when printing to a laser printer, then I suspect the printer doesn't have enough memory to handle complex graphics (high-resolution images, multiple drawing layers). ... Our design calls for call out boxes, pictures, subtitles, etc. that we have been inserting into text boxes. ... This generally happens when we've been inserting pictures and have multiple text boxes with pictures and text - but not always. ...
    (microsoft.public.word.docmanagement)
  • Re: Using a check box to filter a combo box
    ... filters from multiple objects. ... fit "Model B". ... If both boxes are checked, all that should be left to ...
    (microsoft.public.access.formscoding)
  • Re: change multiple text boxes by changing one combo box
    ... Are the "multiple text boxes" bound to fields in the form's record source or ... source and not store the additional fields. ...
    (microsoft.public.access.gettingstarted)
Loading