search using first 3 letters of the text box 1

[discover142]

i have a field named 'Payer' in a form called LogTx.
When user clicks Open, I'd like to check and see if there's another data with the same payer name. I have no problem doing this using DLookUp or query but I was wondering if you can call records that contains first 3 letters from the 'payer' text box. is this possible?

 

[PHV]

A starting point:
Like Left([Forms]![LogTx]![Payer], 3) & '*'

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[discover142]

perfect. thank you phv