Changing the search field in combo box in a subform

[julie67]

I have a subform that allows the user to select names to attend events. The form, fmevents, has the subform, fmAttendees. The record source for the subform, fmAttendees, is a query linking the table, Names, and the table, tblAttendees by the fields, AttendeeID & NameID.

The combo box for looking up names is the primary key, NameID, which is an autonumber. The autonumber means nothing to the user. I would like to change the combo box for sorting to be the last name (with the full name in view to differentiate multiple occurences of the same last neame). When I change the last name field to a combo box, it only shows the last name, and upon record selection, it does not link the NameID and other fields. It thereby creates a new NameID in the Names table. It doesn't seem like it is linking the info.

I know enough about combo boxes and subforms to be dangerous.

Any suggestions on making this work?

Thanks,
Julie

 

[willir]

See post...
Access tables

 

[julie67]

Thanks--I already figured it out, but it is nice to know I'm on the right track.