[belajar-access] edit recordset

 

gimana cara edit data pada tabel2 dengan code :

Set db = CurrentDb
Set rs = db.OpenRecordset("table2")
rs.edit
rs("id") = Me![text0]
rs("nama") = Me![text1]
rs("alamat") = Me![text2]
rs("kelas") = Me![text3]

rs.Update
rs.Close

-edit data berdasarkan file yang di munculkan via combobox table2 tsb.
-edit di atas hanya bisa akurat jika hanya 1 record saja, tapi kalau lebih jadi ter edit semuanya

SrchCrit = "[Project_Number] ='" & Me![Project_Number] & "'"
rs.FindFirst SrchCrit

sy coba tambahan kode ini tapi error.., atau kalau cara lain untuk update ke tabel dari form?

tks

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 11
• New Files 1

Visit Your Group

SPAM IS PROHIBITED

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___