First, here are some components of my database:

tblPersonnel contains many fields including- PersID (PK)
tblPersQuals contains many fields including - fldQual,
PersID (FK)
tblQualifications is a 'Master' list of Qualifications (No
duplicates)

frmQualificationSelect  (source tblPersQuals) - is
specific to a single person; contains a listbox (lstQuals)
based on tblQualifications; and contains a subform
sfrmPersQuals, which is based on tblPersQuals.

By double-clicking values found in lstQuals, my goal was
to populate these values in the fldQual field found in
sfrmPersQuals. I have achieved this through an Update
Query.

My problem, however, is that I am able to populate
sfrmPersQuals with the same qualification more than once
(i.e. 2 or more instances of "Access" , "PG" etc).  

My uneducated guess is that I need some type of code to
loop through the current recordset found in sfrmPersQuals
to see if the qualification already exists and have a
MsgBox pop up with something like "This qualification
already exists". The problem is that I don't know how to
loop through the recordset.

Any help would be greatly appreciated.
Thank you
Denis