>>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