"HollyylloH" wrote:

> I have created a VB form in Visual Studio.net with connections to a SQL 2000
> database. I am pulling info from 3 tables into the form. I have created a
> Next button that takes me from record to record using this code:
>
> Me.BindingContext(DsAll1, "Table1").Position += 1
> Me.BindingContext(DsAll1, "Table2").Position += 1
> Me.BindingContext(DsAll1, "Table3").Position += 1
>
> I am recieving this error on Table3:
> --
> An unhandled exception of type 'System.Exception' occurred in
> system.windows.forms.dll
>
> Additional information: DataBinding could not find a row in the list that is
> suitable for all bindings
> --
> I noticed in the Autos Window Table3:
> Me.BindingContext(DsAll1, "Table1").Position Value = 1
> Me.BindingContext(DsAll1, "Table2").Position Value = 1
> Me.BindingContext(DsAll1, "Table3").Position Value = -1
>
> Table3" Value = -1. I have tried unsuccessfully to reset this to 1 on
> loading the form using:
> Me.BindingContext(DsAll1, "Table3").Position = 1
>