New feature! Upgrade and increase expert visibility of your issues with Priority Questions.
ADO Set cn = New ADODB.Connection Set rs1 = New ADODB.Recordset cn.Open "Provider=SQLNCLI;Server=10.0.0.10\SQLExpress;Database=FDThomasQC;Trusted_Connection=yes;" rs1.Open "SELECT WorkReleaseID FROM tblWorkRelease WHERE WorkReleaseID = " & cboReleaseNo, cn, adOpenKeyset rs1.MoveFirst rs1.Find "[WorkReleaseId] = " & cboReleaseNo.Value If rs1.EOF Then MsgBox "Not Found" Else 'HOW DO I POPULATE FORM FIELDS HERE? End If
Join the community of 500,000 technology professionals and ask your questions.