>>
>>Do you have temp relations (SET RELATION) between controlsource and rowsource tables? If yes, remove them.
>
> No, no SET RELATIONs. They're not related in the DB container either.

Another problem is general setting of your interface. As I understand you have one-to-many lookup-to-master tables, so if you search by foreign key in master table you may get many tables not one.