Solved Open Form Where Condition Text Field

[cktcPeterson]

I have a student ID that looks like this

AB123456

I want to open a form based on a form

I have a combo box with a macro. I am stumpted on the where condition because it is a text field.

=" [Student ID] =" & [Student ID]

 

[theDBguy]

Try:

="[Student ID]='" & [Student ID] & "'"

 

[cktcPeterson]

Exactly what I was looking for.
Thanks

 

[Josef P.]

[something OT]

Since merging a filter string is an ongoing issue, I was about to give the tip to use BuildCriteria, as this will create a correct filter expression.

Example:

Dim FilterValue As String
Dim FilterString As String

FilterValue = "AB123456"
FilterString = BuildCriteria("[Student ID]", DataTypeEnum.dbText, FilterValue)
Debug.Print FilterString

This fits in principle, unless you include " in the string.

FilterValue = "abc""xyz" ' ... Value = abc"xyz
FilterString = BuildCriteria("[Student ID]", DataTypeEnum.dbText, FilterValue)
Debug.Print FilterString

=> [Student ID]="abc"xyz"
I use my own method, so I have too little practice with the built-in BuildCriteria.
But I would have expected Access.BuildCriteria to at least double the ".

However, it can handle such an expression:

FilterValue = "abc or xyz"
FilterString = Access.BuildCriteria("[Student ID]", DataTypeEnum.dbText, FilterValue)
Debug.Print FilterString

=> [Student ID]="abc" Or [Student ID]="xyz"

What do you suspect is coming with this filter value:

FilterValue = "abc;xyz"

 

[theDBguy]

Exactly what I was looking for.
Thanks

Glad to hear you got it to work. Good luck with your project.