Data Access & Tab Control

[rich_wenger]

Hi, and thanks for your interest. I have some databound textboxes that are grouped on a number of pages in a tabcontrol. I use a button to call up a dialog box to pull data from a lookup table to speed populating some of the textboxes on the tab control. Updates seem to work fine untill I add some additional code in the Update event to check for null conditions. Then it gets strange, after I fill the textboxes from the lookup dialog I have to click in one (doesn't seem to matter which) of the filled textboxes for the updated information to be posted to the database. I have no code associated with tabcontrol or textbox mouse events on the form. Code To Open Dialog (Form1)======================================== private void btnLmoLookup_Click(object sender, System.EventArgs e) { Form2 LmoLookup = new Form2(); LmoLookup.StartPosition = FormStartPosition.CenterParent; if( LmoLookup.ShowDialog() == DialogResult.OK ) { txtBoxDocName.Text = LmoLookup.docFullName; } LmoLookup.Dispose(); } Code To Declare Public Variable (Form2)================================== public string docFullName { get{return this.dsExtPhysLookup1.Tables["tblExternalPhysicians"].Rows[this.listBox1.SelectedIndex]["docFullName"].ToString();} } Code To Perform Update (Form1)=========================================== if(this.txtBoxDocName.Text.Trim().Length == 0) { this.dsPatientIndex1.Tables["tblPatientIndex"].Rows[this.BindingContext[dsPatientIndex1, "tblPatientIndex"].Position]["patientRefDName"] = DBNull.Value; } else { this.dsPatientIndex1.Tables["tblPatientIndex"].Rows[this.BindingContext[dsPatientIndex1, "tblPatientIndex"].Position]["patientRefDName"] = txtBoxDocName.Text.Trim(); } this.BindingContext[this.dsPatientIndex1, "tblPatientIndex"].EndCurrentEdit(); this.sqlDataAdapter2.Update(this.dsPatientIndex1); -- modified at 8:53 Friday 7th October, 2005