---------- > > >>Jeff > > > >something like > > > > select id_number from this_table where id_number = this.value into > cursor temp > > if reccount('temp') > 0 > > =messagebox('This id number has already been entered!') > > use in temp > > return 0 > > endif > > > > That's perfect, reccount is exaclty what I was looking for! > > Thanks again! > > Jeff Jeff, note that the syntax is a little different for views and to get the new subset you'd have to REQUERY (see the help file) Arnon