[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 181
  • Last Modified:

how to add a new record to database using textbox

Hello friends,

I connected some textbox controls to a adodc , I want to add new records using those textbox controls.

Thank you very much,
Azadeh
0
aa_azadeh
Asked:
aa_azadeh
1 Solution
 
TylerTheWimpCommented:
'txt1 is a textbox on your form that links to field "a" in your table
'txt2 is a textbox on your form that links to field "b" in your table
'rs is a module level or application level recordset that has an active connection to your table

private sub addRecord()

  rs.addnew
  rs("a").value = txt1.text
  rs("b").value = txt2.text
  rs.update

end sub
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now