Form query question

[Subotai]

I have a form with a combo box on it that I am using to select records. I have the row source for the combo box set to a query that contains two fields (first name and last name). I want to be able to go to a record based on the combination of the two. Right now it will only go the the first instance of the last name. The table the query is pulled from is indexed via a MemberID field.

The after update event is set to a macro that has two steps in it. A Gotocontrol and a Findrecord. The Gotocontrol is set to Lastname, the name of the field in the query. The find record :"Find What" is set to =[Combo48] which is the name of the combo box that I m using. The combo box has a pull down to show the query but if you select any record of a group of identical last names, it selects the first one.

Any help would be appreciated.

[NassauBob]

Would you consider having the combo box's source be the concatenated first and last name values from the query, like "Beason, John", and have the report's data source use that as a filtering parameter?