Using VBA filter on one or more fields

[niallmc]

Hi,
I am trying to open a VB form based on stLinkCriteria, using 2 fields.
It is successful for me if both fields have information in them.
However I wish to be able to search on either field

Here is my code
Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmOpen"
stLinkCriteria = "[Code1]=" & "'" & Me![Code1] & "'" & " AND
[Code2]=" & "'" & Me![Code2] & "'"

DoCmd.OpenForm stDocName, , , stLinkCriteria

Can you tell me if it's possible to code it in a way to include AND/OR so that one filed can be blank

Thanks very much
NIall

[MMcCarthy]

stDocName = "frmOpen"
stLinkCriteria = "[Code1]=" & "'" & Me![Code1] & "'" & " OR
[Code2]=" & "'" & Me![Code2] & "'"

This will return all records where either field is true.

Hi,
I am trying to open a VB form based on stLinkCriteria, using 2 fields.
It is successful for me if both fields have information in them.
However I wish to be able to search on either field

Here is my code
Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmOpen"
stLinkCriteria = "[Code1]=" & "'" & Me![Code1] & "'" & " AND
[Code2]=" & "'" & Me![Code2] & "'"

DoCmd.OpenForm stDocName, , , stLinkCriteria

Can you tell me if it's possible to code it in a way to include AND/OR so that one filed can be blank

Thanks very much
NIall

[niallmc]

Thanks for that.

What I am trying to do is return all records when eith one is true OR both fields are true. OR only works with one field.
Any suggestions?

niall

[MMcCarthy]

Naill

I don't understand the question, if both are true then this satisfies that either are true. You should get a result either way.

Thanks for that.

What I am trying to do is return all records when eith one is true OR both fields are true. OR only works with one field.
Any suggestions?

niall