Multiple combobox selections in subform to filter other comboboxes

[June7]

Typing into combobox should narrow down the list if the AutoExpand property is enabled. Yes, the ID is the value saved but users should not see it. They start typing last name and the AutoExpand should show only records in the list that match the user input.


Adding new records into a lookup table 'on-the-fly' is what the combobox (or listbox) NotInList event is for. http://www.blueclaw-db.com/access_no...ed_example.htm

[lirantha]

Typing into combobox should narrow down the list if the AutoExpand property is enabled. Yes, the ID is the value saved but users should not see it. They start typing last name and the AutoExpand should show only records in the list that match the user input.

AutoExpand is enabled, but I'm getting the error "Control can't be edited; it's bound to the expression 'PubID'." Revised database attached in case I've assigned the properties incorrectly. InscriptionsNormJune7.zip

Adding new records into a lookup table 'on-the-fly' is what the combobox (or listbox) NotInList event is for. http://www.blueclaw-db.com/access_no...ed_example.htm

Thanks for the link; I'll see what I can do with it.

[June7]

Remove the = sign from the combobox ControlSource.