Binding a textbox in a dataset with multiple tables

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Gregory Paff (gpaff_at_ptcllc.com)
Date: 05/19/04


Date: Wed, 19 May 2004 13:43:41 -0400

I have a Dataset with 4 tables (1 master and 3 child)
        Table A <- Table B
        Table A <- Table C
        Table A <- Table D

On the form there is a table control with 4 tabs
Tab1 consists textboxes from Table A
Tab 2 consists of a datagrid with Table B
Tab 3 consists of a datagrid with Table C
Tab 4 consists of a multiline TextBox representing from Table D

I am in experiencing a problem with the binding of a textbox in tab D

1) the data disappears from the textbox when switching tabs
2) when saving the data is never sent back to the dataset

I am binding the textbox by the relationship:
txtNote.DataBindings.Add("Text", dsReport, TableA.TableATableB.Note");

I can get the table to not disappear by setting the txtNote.BindingConext =
this.BindingContext. However this does allow the dataset to be updated when
I call EndCurrentEdit. It seems like it is never creating a detached row to
populate. Is this something I need to handle manually?



Relevant Pages

  • Re: Tab functionality for VBA form in Excel 2004 for mac / macinto
    ... I do have the Mac set to tab from textbox to textbox and ... computer with Excel 2008. ... One of the problems I can't fix, however, is the tab functionality of the ... I must click in each box to move the control. ...
    (microsoft.public.mac.office.excel)
  • Re: Purging window messages under a given condition!
    ... of the tab control. ... matter what control on the page I'm trying to activate. ... Did you look at the Validating event on the TextBox? ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: control source to update text box
    ... procedure is still in the events tab. ... of the reference # text box. ... Also check that the control source for the textbox that receives ...
    (microsoft.public.access.formscoding)
  • TAB Index and TabStop; sequences
    ... --The last textbox unhides a command button ... After data is entered into that last textbox, pressing tab makes the cursor ... At any rate, I don't -think- the label TabIndexes are a problem, but ... ...
    (microsoft.public.vb.general.discussion)
  • Re: label control wont update
    ... I did remove the label and put in a textbox instead and then ... I do need change event code because the 2nd tab is a drill down from the ... On the first tab you set focus to a row on the subform. ...
    (microsoft.public.access.formscoding)