FindFirst Criteria Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Back
Top