Ok Changed it to ;
Code:txtprojnameupdt.Text = Replace(txtProjname.Text, "'", "'") Me.QryactiveprojectsTableAdapter.Fill(Me.Projstatus.qryactiveprojects) cmbactiveproj.SelectedIndex = cmbactiveproj.FindStringExact(txtprojnameupdt.Text)
Then I had a txtprojname.text = 4567 - test app changed to 4567 - test app'.
The value of cmbactiveproj, txtprojname and txtprojnameupdt is identical i.e., 4567 - test app'.
However, an error message is prompted as shown below -
Unclosed quotation mark after the character string '4567 - test app''. Incorrect syntax near '4567 - test app''.
When you click ok, the whole form is populated fine. Why do I receive this error? Thanks




Reply With Quote