find record with composite PK

[QueenKirsty]

Hi. I am trying to move to a particular record on a form where the form has a composite PK.

The PK is made of 3 fields: ModuleID, Precedence and RecordTypeID

I have always used docmd.findrecord before but I can't see how to do this with a composite PK.

Any suggestions?

Thanks
Kirsty

 

[pbaldy]

Along the lines of

Field1 = 1 And Field2 = 2 And Field3 = 'C'

Note text values would be enclosed in quotes.