Brian,
>I'm getting data back from the query. I can see the expected record in the databound controls. The pick text box and button are part of a user control that I made ( the basic custome information and lookup will be use on a few other forms) maybe this is the problem? I'll try the form without it.
It's really contained within the business object so the user control shouldn't make a difference. Is the result being stored into the business object's default DataTable? By default, that's the only way the DataRow property gets populated.
Best Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com