DoCmd.OpenForm

[Guest]

I am trying to open a form that filters on several criteria

here are the two conditions:
[gain] >2 and [type] = "special pass"
[gain] >2 and [type] = "pass"

gain is a number field, type is a text field

Here is what I tried:

DoCmd.OpenForm "logfrm", , , "[gain] > 2 AND [type] = 'special pass'" Or
"[gain] > 2 AND [type] = 'pass'"

 

[Guest]

where abouts are the values coming from

 

[tina]

try the following, as

DoCmd.OpenForm "logfrm", , , "[gain] > 2 AND ([type] = 'special pass' Or
[type] = 'pass')"

the above goes on one line, of course, regardless of line wrap in this post.

hth

 

[Jeff Boyce]

What happens when you try that?

Have you used Access HELP to make sure your syntax is correct?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

I am setting the values. They won't change

where abouts are the values coming from
--
Let me know if I have helped by replying or clicking question answered

Falty

I am trying to open a form that filters on several criteria

here are the two conditions:
[gain] >2 and [type] = "special pass"
[gain] >2 and [type] = "pass"

gain is a number field, type is a text field

Here is what I tried:

DoCmd.OpenForm "logfrm", , , "[gain] > 2 AND [type] = 'special pass'" Or
"[gain] > 2 AND [type] = 'pass'"

 

[Guest]

the values are in the form being opened in the [gain] field and the [type]
field.

where abouts are the values coming from
--
Let me know if I have helped by replying or clicking question answered

Falty

I am trying to open a form that filters on several criteria

here are the two conditions:
[gain] >2 and [type] = "special pass"
[gain] >2 and [type] = "pass"

gain is a number field, type is a text field

Here is what I tried:

DoCmd.OpenForm "logfrm", , , "[gain] > 2 AND [type] = 'special pass'" Or
"[gain] > 2 AND [type] = 'pass'"

 

[Guest]

Forgive me if i am being stupid, but if you are always filtering by those
criteria could you not add them to a query an set that query as the reord
source
--
Let me know if I have helped by replying or clicking question answered

Falty

What happens when you try that?

Have you used Access HELP to make sure your syntax is correct?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am trying to open a form that filters on several criteria

here are the two conditions:
[gain] >2 and [type] = "special pass"
[gain] >2 and [type] = "pass"

gain is a number field, type is a text field

Here is what I tried:

DoCmd.OpenForm "logfrm", , , "[gain] > 2 AND [type] = 'special pass'" Or
"[gain] > 2 AND [type] = 'pass'"

 

[Guest]

Thanks Tina

 

[Mike Mueller]

Same thing as I was thinking

Forgive me if i am being stupid, but if you are always filtering by those
criteria could you not add them to a query an set that query as the reord
source
--
Let me know if I have helped by replying or clicking question answered

Falty

What happens when you try that?

Have you used Access HELP to make sure your syntax is correct?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am trying to open a form that filters on several criteria

here are the two conditions:
[gain] >2 and [type] = "special pass"
[gain] >2 and [type] = "pass"

gain is a number field, type is a text field

Here is what I tried:

DoCmd.OpenForm "logfrm", , , "[gain] > 2 AND [type] = 'special pass'"
Or
"[gain] > 2 AND [type] = 'pass'"

 

[tina]

you're welcome