Goto an existing record based on the values in the new record

Goto an existing record based on the values in the new record

Post by Hallgei » Wed, 26 Jan 2005 23:41:16


When registering a new record in a form I have been using the FindRecord
command to go directly to an existing record if the, for instance,
customerid already exist in another record.
My problem is now that I have to check for existing records, and go to this
if I find any, based on three fields a give values. (non of them is the
primary key).
I think that I could find the primary key of a matching existing record, but
I that know how to goto this record.

I hope I make myself understood and I appreciate any hints.

--
mvh
Hallgeir Pettersen