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