Joe,

>This all AGAIN, seems to work when UPDATING records but not when ADDING new records.
>In the code listing at the end of the post, CompanySelected and VisCompanySelected are valued correctly yet any way I try to save the row or dataset fails with CANNOT INSERT NULL INTO COMPANYNAME in Vistors

>Please help me understand what is (or is not) happening correctly!
>
>So... even though I have set the mmPicker to data bind via
>BindingSource: Company
>BindingSourceMember: CompanyName
>BindingValueSource: Visitor
>BindingValueSourceMember: CompanyName

Maybe I don't understand how your picker is being used, but it looks like you should be able to set the properties to the following, since you the value returned from the PickList form is the value you want to store in the Visitor's CompanyName:

BindingSource: Visitor
BindingSourceMember: CompanyName
BindingValueSource:
BindingValueSourceMember:

Regards,