Hello,

I'm using Access 2000 and VB6.

I need to do a search to check if a record exists in a table, if it does I then need to display a message saying so.

The record being searched for is a Number in a field named "OurRef" in a table named "RecordInUse".

Any ideas because I think I am missing the obvious sollution.

Thanks,
SKM