Passing Operators from Form to Query Criteria

[Michael]

Hi Folks - Is there a way to pass operators such as >=, <=, <>, like ,etc.
from a form into a query's criteria row?

Thanks,

Michael

 

[KARL DEWEY]

From all I have read you can not but there is a work around. Use checkbox or
options group to set criteria for calculted fields.
Give a little more details of what you are trying to do.

 

[KARL DEWEY]

The query in design view would look like this ---
FIELD: X: [FORMS]![YOURFORM]![FRAME1] [SomeDataField]
TABLE:
SORT:
CRITERIA: 1

[FORMS]![YOURFORM]![TEXT1]

2
<=[FORMS]![YOURFORM]![TEXT1]
3
<>[FORMS]![YOURFORM]![TEXT1]

 

[Michael]

Here's the example:

I have an option group with 3 choices: Open, Not Open, All. When
I choose Open, I update an hidden text box with the word "open". That
textbox value is passed to a query field's criteria. That field contains
values such as Open, Pending, Closed, N/A. No problem so far.

However, when I choose Not Open in the option group choices, I want to be
able to pass the criteria <>"open" to the query. What's the best way to
handle this? Make sense?

The query in design view would look like this ---
FIELD: X: [FORMS]![YOURFORM]![FRAME1] [SomeDataField]
TABLE:
SORT:
CRITERIA: 1

[FORMS]![YOURFORM]![TEXT1]

2
<=[FORMS]![YOURFORM]![TEXT1]
3
<>[FORMS]![YOURFORM]![TEXT1]

From all I have read you can not but there is a work around. Use
checkbox or
options group to set criteria for calculted fields.
Give a little more details of what you are trying to do.

 

[KARL DEWEY]

As I said in design view of your query add a new field like this --
X: [FORMS]![YOURFORM]![FRAME1]
In the criteria row enter the option group value that represents Not Open.
In the same row under your status enter <>"open" so that when you select
Not Open it will work.

Here's the example:

I have an option group with 3 choices: Open, Not Open, All. When
I choose Open, I update an hidden text box with the word "open". That
textbox value is passed to a query field's criteria. That field contains
values such as Open, Pending, Closed, N/A. No problem so far.

However, when I choose Not Open in the option group choices, I want to be
able to pass the criteria <>"open" to the query. What's the best way to
handle this? Make sense?

The query in design view would look like this ---
FIELD: X: [FORMS]![YOURFORM]![FRAME1] [SomeDataField]
TABLE:
SORT:
CRITERIA: 1

[FORMS]![YOURFORM]![TEXT1]

2
<=[FORMS]![YOURFORM]![TEXT1]
3
<>[FORMS]![YOURFORM]![TEXT1]

From all I have read you can not but there is a work around. Use
checkbox or
options group to set criteria for calculted fields.
Give a little more details of what you are trying to do.

:

Hi Folks - Is there a way to pass operators such as >=, <=, <>, like
,etc.
from a form into a query's criteria row?

Thanks,

Michael