I've played around with this and have figured most of it on how to set the properties of most controlss in the designer. I have 2 check boxes I need to set the values on but do not know how. 2 fields one for each in the db with a char(1) value, can be Y or N. If it a Y in the db how would I set it as checked on the form?
and then where the record is updated it is like soCode:'cboPosition ' Me.cboPosition.DataBindings.Add(New System.Windows.Forms.Binding("SelectedValue", Me.FmfieldmanmasterBindingSource1, "position_name", True)) Me.cboPosition.DataBindings.Add(New System.Windows.Forms.Binding("Text", Me.FmfieldmanmasterBindingSource1, "position_name", True)) Me.cboPosition.Enabled = False Me.cboPosition.FormattingEnabled = True Me.cboPosition.Location = New System.Drawing.Point(80, 104) Me.cboPosition.Name = "cboPosition" Me.cboPosition.Size = New System.Drawing.Size(220, 21) Me.cboPosition.TabIndex = 5
Code:Fieldman_masterTableAdapter.UpdateQuery(txtFieldPersonFirstName.Text, txtFieldPersonLastName.Text, cboFieldPersonStatus.Text, txtfieldPersonAddress1.Text, txtfieldPersonAddress2.Text, txtfieldPersonAddress3.Text, txtFieldPersonCity.Text, cboFieldPersonState.Text.ToUpper, mtbFieldPersonZipCode.Text, txtFieldPersonEmailAddress.Text, mtbFieldPersonHomePhone.Text, mtbFieldPersonWorkPhone.Text, mtbFieldPersonExtension.Text, mtbFieldPersonPager.Text, mtbFieldPersonMobilePhone.Text, mtbFieldPersonVehiclePhone.Text, mtbFieldPersonFax.Text, cboFieldPersonAffiliation.Text, cboPosition.Text, cbxDivisionManager.XXXXX, cbxReagionManager.XXXXX, txtFieldPersonFieldNumber.Text)




Reply With Quote