FindFirst Criteria Help

[Guest]

I am using VBA code with the FindFirst Criteria on a Table. The Field I am
look at if called [F1].

The Content of [F1] field has things like xxxx (y), >, Null where xxxx is
any alphanumeric value and is followed by 1 space with "(y)" where y is
"LL", "LR","RR", or "RL"

I was using a FindFirst method to look for xxxx (y), and I can find it. In
reality, I only have a variable called Chk which has the xxxx part only. I
need a way to just compare that part only.

Thanks.

 

[Guest]

rst.FindFirst("left([F1],4) = '" & chk &"'")