Search using a Combo Box

[Guest]

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

 

[Mr. B]

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

JS,

If your users want to be able to specify the Name of Group then, if
the data is structured as you have described, what you can do is just
present them with a list of unique values from that field. Then upon
them making a selection, you would have to display a list of all of
the records that meet the criteria selected. Then they can select the
record with the ID they want to use.

Hope this helps.

Mr. B