hello i am Software engg student
i occured some of the problem between the Data Report Connetion
occured error in the code is "Run time Error '8574': the object "G1" was not Found " G1 is Taken label in Data Report
On Error GoTo errhandler
key = regdText2.Text
Call dbConnect
Set rs = Nothing
SQL = ("select * from Booting where reg_no=" & key)
rs.open SQL, Conn, adOpenDynamic, adLockPessimistic
Set DataReport3.DataSource = rs
DataReport3.Sections("Section4").Controls("G1").Caption = lbname.Caption
DataReport3.Sections("Section1").Controls("G2").Caption = ldnation.Caption
DataReport3.Sections("Section1").Controls("G3").Caption = lbage.Caption
DataReport3.Sections("Section1").Controls("G4").Caption = lbaddress.Caption
DataReport3.Sections("Section1").Controls("G5").Caption = lbmap.Caption
DataReport3.Sections("Section2").Controls("G6").Caption = lbdeploy.Caption
DataReport3.Sections("Section5").Controls("G7").Caption = lbdate.Caption
DataReport3.Sections("Section5").Controls("G8").Caption = lbplace.Caption
DataReport3.Show vbModal
' rs.close
Exit Sub
Call dbClose
errhandler:
Call MsgBox("Please Enter Register No", vbOKOnly, "Error")
Exit Sub