I have a table which has a primary key made up of to fields from the table; The fields are opType and opLocation. Although each of the two fields can have duplicated, when used together as the primary key, the key must be unique. I would like to return a recordset of all records with the same opType. Could someone give me an example of the VB/VBA code to do this and also one to retrieve the single record which matches a specified primary key. I have been doing this sort of thing by using an SQL SELECT string, but am wondering if there is a simpler or better way. My background is (traditional 3GL) programming from which I understand the use of keys and partial keys but can't quite get my head around how this applies to the jet mdb structure. Cheers TonyS.