Solved Open form with multiple where conditions (Text Fields)

[Snowflake68]

I want to open a form to a specific record with two where conditions. I have it working with one but just cannot get the syntax correct to join the two together. I have tried using AND but just cant get the quotes in the correct place.

These are the two conditions I would like to join together please (THEY ARE BOTH TEXT FIELDS)

="[QuoteReference]=" & "'" & [QuoteRef] & "'"

AND

"[AccountReference]=" & "'" & [AccountRef] & "'"

 

[June7]

AND must be within quotes. Where are you using this that you need = sign?

="[QuoteReference]='" & [QuoteRef] & "' AND [AccountReference]='" & [AccountRef] & "'"

 

[Snowflake68]

AND must be within quotes. Where are you using this that you need = sign?

="[QuoteReference]='" & [QuoteRef] & "' AND [AccountReference]='" & [AccountRef] & "'"

Thank you so much, this works perfectly