When you create a data bound form, you bind it using the syntax
Dim dt As DataTable = GetDataTable()
MyTextBox.DataBindings.Add("Text",dt,"myFieldName")
Function GetDataTable As DataTable
* Put code here to return the DataTable you want this form to bind to.
* You could check the logon to determine which table to access or some
* other criteria.
Return MyDataTable
End Function
>Cathi,
>We don't want to copy the tables. We want the data entered manually, by two different operators, so errors in reading the apps or entering the data can be resolved by a report comparing the two tables.
>
>What I'd like to do is use one form for this, switching which table I use, on bound controls, so I don't have to maintain changes across two forms.
>
>Thanks.
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi