Query with field in a form

  • Thread starter Thread starter Lasse T
  • Start date Start date
L

Lasse T

Hello!!

Sins I´m using a swedish Access 2000 I don´t know the english word for the
different expressions but I will try to explain my problem the best I can
and I hope that someone can understand and give me a hint.

I have a form with 4 list boxes where I can highlight four values. This form
is based on a query and it will present me with all the items in the items
table where all four vaues are true. In the query I have like this
[Forms]![formname]![field1] and tree more like that. It works fine but it
only works when i highlight all four values. I would like the query to
understand that if I only highlight one, tvo or three of the values the
value(s) not highlighted should mean "all". Can anyone help me with that?

Thanks in advance

Lasse T
------------------
 
Like [Forms]![YourForm]![YourListtBox] & "*" or Is Null

The "*" is for when you do not select and "Is Null" for when the field may
be empty.
 
Thank You very much. It works just as I wanted.

Lasse T
----------

KARL DEWEY said:
Like [Forms]![YourForm]![YourListtBox] & "*" or Is Null

The "*" is for when you do not select and "Is Null" for when the field
may
be empty.

Lasse T said:
Hello!!

Sins I´m using a swedish Access 2000 I don´t know the english word for
the
different expressions but I will try to explain my problem the best I can
and I hope that someone can understand and give me a hint.

I have a form with 4 list boxes where I can highlight four values. This
form
is based on a query and it will present me with all the items in the
items
table where all four vaues are true. In the query I have like this
[Forms]![formname]![field1] and tree more like that. It works fine but it
only works when i highlight all four values. I would like the query to
understand that if I only highlight one, tvo or three of the values the
value(s) not highlighted should mean "all". Can anyone help me with
that?

Thanks in advance

Lasse T
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pull criteria from a Form 2
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Query Values with < > or = 2
Use Table field in query criteria 1
set value of txtbox in form = select query 2
Help with a partial match query 6
result query on a form 1
Checking if data exists another table and, if yes, extracting a value 0

Back
Top