PMFJI
Kevin
I just wanted to highlight a problem with binding to RecordSets, if EOF is reached, you get nasty errors occurring, and the textboxes will un-bind, if you have Valid and Refresh code in each class, they can check for EOF before attempting to display a value.
Kev
>Jim,
>
>You are correct - the Biz object is what the form should be seeing.
>
>While I like the ideas you expressed in your samples, there is one thing
>I'm not sold on - No bound fields.
>
>I'd like to be able to say;
>
>
>ThisForm.oBizObj.Navigate("Next")
>ThisForm.Resfresh()
>
>
>This Biz object could do a oRecordSet.MoveNext, and if the
>controlsources are set to:
>
>
>This.ControlSource = ThisForm.oBizObj.oRecSet.Fields("somefieldname").Name
>
>
>This is all assuming an ADO data source, of course. But it does also expose the
>recordset object at the Biz object level.
>
>Not sure what the right approach is