Re: Parameter query

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

In the criteria, use a bit extra like:

[Forms]![YourForm]![YourComboBox] OR
([Forms]![YourForm]![YourComboBox] Is Null)

(type as *one line is the criteria row).


--
HTH
Van T. Dinh
MVP (Access)


"Ray" <NoSpan-lizhiqiang1@xxxxxxxxx> wrote in message
news:%235k460yjFHA.2920@xxxxxxxxxxxxxxxxxxxxxxx
> 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
>


.

Relevant Pages

  • Re: Compound Keys, Update
    ... Karl asked that question and not I and therefore I didn't know ... HTH ... Van T. Dinh ...
    (microsoft.public.access.queries)
  • Re: Update Query specific to Record
    ... Kim. ... "Van T. Dinh" wrote: ... > next available Column and in the criteria row of this column, ...
    (microsoft.public.access.queries)