Snowflake68
Registered User.
- Local time
- Today, 00:39
- Joined
- May 28, 2014
- Messages
- 464
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] & "'"
These are the two conditions I would like to join together please (THEY ARE BOTH TEXT FIELDS)
="[QuoteReference]=" & "'" & [QuoteRef] & "'"
AND
"[AccountReference]=" & "'" & [AccountRef] & "'"