Thanks for responding Chris,

The actual code that I,m using is almost identical to yours,
but my problem actually lies within the If statement. My records are displayed in 10 text boxes connected to Data1 because this is what was wanted(I would have preferred a DBGrid system). I made life hard for myself by not using an array of textboxes, so I'll have to live with that mistake now.

What I need is something like

If......(result)....Then
Data1...display (result) in textboxes

rather than debug print, if you see what I mean

I need Data1 to move to that particular record, and I've tried countless lines without success.

Thanks again
GRAHAM