Can anyone help me with the syntax in VBA for comparing one variable against a closest like field in tbl_somewhere.Field (text field) ,I know it must be pretty simple to others in the know but to me well I am a still a novice/numpty
I,ve tried searching and saw lots of uses, but can't quite get it right for my purposes
I imagine it to be something like the following (close but no cigar):
Code:iif DCount=('variableName' Like "me![Feild]") > 0 Then 'show record or do something else msxbox "no like matches found", vbok 'do something else