I have a combo box created in a form for users to search by the "ID" field.  
The ID field is unique and never duplicated.  For example, user types "71" in
the ID field and the record is populated.

Fields in Combo Box:

Id      Name of Group        Group No.       Effective Date
71     Deer Park                555555           12/01/07
68     Deer Park                555555           12/01/07
74     Deer Park                555555           06/08/07

My problem is the user wants another Combo Box to search by the Name of the
Group.  The fields "Name of Group" "Group No." and "Effective Date" may have
the same data.  The user wants to be able to type the first letter of the
name of the group in the lookup.

When I create my combo box using the "Name of Group" field Access only
returns the first "Name of Group" even if it is listed more than once.   I do
know why Access is doing this because I have no unique field identified.  Is
possible to create this kind of combo box for the user?  I have the ID in the
lookup but it still doesn't return the correct record.  I was told maybe a
lookup query would help but found no luck with that.

If someone could help, I would appreciate!
JS