You might also consider having a query with a WHERE clause and input
parameters for the primary key.

Close;
ParamByName( 'AKEY' ).AsString := 'some val';
Open;

This is the fastest way to pull up a single record.

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com