Member Avatar for tommuhumuza

I have this code am when i try to execute it give an error
where am i going wrong

Set Rs = New ADODB.Recordset
Rs.Open "Select stank from sidetank where job_id='" & Label18.Caption & "'", FrmMother.Db, adOpenKeyset, adOpenDynamic
Rs(0) = Val(Rs(0)) + Val(Text7)
Rs.Update
Rs.Close

Will be glad if i get help

Edited by pritaeas because: Added markdown.
  • 2 Contributors
  • 1 Reply
  • 106 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Reverend Jim
Member Avatar for Reverend Jim

Will be glad if i get help

Will be glad if you provide details.

  1. what is the error message
  2. what line throws the error
  3. what is the connection string
  4. what type of database are you connecting to
  5. what is FrmMother.Db
Edited by Reverend Jim
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.