I have a form (frmAttendeeProjects) with a subform (subAttendeeProjects). The subform displays multiple projects linked to the Attendee on the main form. They are linked by the "Atten_ID" field.

I am trying to create a combo box on the main form to scroll through a sorted list of Attendees, using a macro. The first part of my macro is "GoToControl" and the control name is "Atten_ID". The second part is "FindRecord" with Find What set to "=[Forms]![frmAttendeeProjects]![Atten_ID]". This occurs on the OnClick event of the combobox. I then have a macro to Requery the combo box on "GotFocus"

When I click the combo box I get my data just fine. But when i try and select a value from the list I get a message that says, "Control can't be edited. It's bound to AutoNumber field 'Atten_ID'".

What am I doing wrong?

If you create your combo box using the Wizard and select the 3rd item on the first screeen, "Find a record..." the Wizard will create the combo box that you are looking for....

Could it be that simple...? :sly:

Thanks for the input Jack, it worked.