stLinkCriteria stupidity

[Geoff Codd]

Hi there,

I am being a complete dumbass, I have a form which I would like to open using the following criteria

SAP_entity = Me![SAP_entity] - Number
Type = "Revenue" - Text Field
source = "ZZZ" - Text Field

One day I'll manage to get my head around this syntax problems

Thanks in advance
Geoff

 

[Mile-O]

stLinkCriteria = "[SAP_entity] = " & Me.[SAP_entity] & " AND [Type] = ""Revenue"" AND [Source] = ""ZZZ"""

 

[Geoff Codd]

Thank you, I forgot to put double quotes around the text values

Thanks
Geoff