>>>
>>>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.

I guess I don't see how that can happen. Once the option is selected off the lookup table, the relation is one to one. Only one record will be returned from the lookup table.

I just got this all to work the way I wanted. I changed:

BoundColumn = 1 (this is my "description" field of the lookup table)
ControlSource = v_estimates.inscompany (value populated in the Click() method)

in Click() I:

Save the lookup (control source) information into the primary table, including v_estimates.inscompany)
Refresh the form.

Thanks, you're responses helped my look at this a little differently.

-Paul