RE: Parameter query

Tech-Archive recommends: Fix windows errors by optimizing your registry

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: Query Combobox Problems
    ... also I can't seem to get the listbox to run the query ... again if I update the combobox. ... havn' found one yet using this method to populate a listbox) ...
    (microsoft.public.access.queries)
  • RE: Help - Updating table entries selected in Listbox
    ... update query to that file....once this trial works correctly then in design ... a multi-select listbox called listboxFileList ... The combobox is populated from ...
    (microsoft.public.access.forms)
  • Re: Parameter query
    ... Ray ... > Use a macro or event in your ComboBox or ListBox to open the query. ...
    (microsoft.public.access.queries)
  • Re: list box updating
    ... How about using a combobox, typing the start of the name, then selecting the ... requery the form, base the form on a query, and in the query, use the value ... ?And what do you mean by "the listbox is updated"? ...
    (microsoft.public.access.formscoding)
  • RE: Drop down in query
    ... Use a macro or event in your ComboBox or ListBox to open the query. ... > I have a db with asset tracking information for server hardware. ...
    (microsoft.public.access.queries)