Re: Parameter query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Use these to get all without selecting any --
Like [Forms]![YourForm]![YourComboBox] &"*"
OR
Like [Forms]![YourForm]![YourListBox] &"*"


"Ray" wrote:

> Karl,
>
> Thanks for your useful advice that resolves my issue.
>
> Is it possible to show all records if I do not enter/select any item in the
> combo box?
>
> Ray
>
> "KARL DEWEY" <KARLDEWEY@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:2E5E5A10-219A-43EF-97C9-CBF8C0918B00@xxxxxxxxxxxxxxxx
> > On a form use a ComboBox or ListBox to select from.
> > In the query use criteria --
> > [Forms]![YourForm]![YourComboBox]
> > OR
> > [Forms]![YourForm]![YourListBox]
> >
> > Use a macro or event in your ComboBox or ListBox to open the query.
> > "Ray" wrote:
> >
> >> Is it possible to have a parameter query where I select the options from
> >> a
> >> list rather than typing the options? If so, may I know how to construct
> >> it.
> >>
> >> Thanks,
> >>
> >> Ray
> >>
> >>
> >>
>
>
>
.

Relevant Pages

  • Re: Parameter query
    ... Ray ... > Use a macro or event in your ComboBox or ListBox to open the query. ...
    (microsoft.public.access.queries)
  • Re: Accessing ListBox Elements From ASP
    ... Listbox is a, correct? ... Ray at work ... Im not good writing english and the first message is write ...
    (microsoft.public.inetserver.asp.general)
  • RE: Parameter query
    ... Use a macro or event in your ComboBox or ListBox to open the query. ... "Ray" wrote: ...
    (microsoft.public.access.queries)
  • Parameter query
    ... Is it possible to have a parameter query where I select the options from a ... list rather than typing the options? ... Ray ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: CustomRenderer for enum
    ... Thanks for your answer Ray but its not that I see incorrect value in ... my combobox from the Renderer its just that I can't see so can't ... select anything other than the default value for the ComboBox. ...
    (comp.lang.java.gui)