Oke Mas Harry solve
Makasih ya…
Regards
Yasman David
QS – PMA - CPM SLO
Rekind Worley Parsons
From: belajar-access@yahoogroups.com [mailto:belajar-access@yahoogroups.com]
Sent: Tuesday, December 02, 2014 6:54 AM
To: belajar-access@yahoogroups.com
Subject: [belajar-access] RE: Tanya Script vb option button
Yasman.David...,
Coba ubah scritp menjadi ini:
Private Sub Fr_pilih_AfterUpdate()
Select Case Fr_pilih.Value
Case 1
Me.RecordSource = "select * from tbl_A"
Case 2
Me.RecordSource = "select * from tbl_B"
Case 3
Me.RecordSource = "select * from tbl_C"
End Select
Me.Refresh
End Sub
Hariyanto (Surabaya)
---In belajar-access@yahoogroups.com, <Yasman.David@WorleyParsons.com> wrote :
Dear Acces Master
Mohon masukannya saya punya table tbl_A, tbl_B dan Tbl_C, dan saya ingin load table tersebut ke dalam satu form dengan menggunakan option button opt_A, Opt_B dan Opt_C. Mohon bantuannya kepada rekan2 untuk script codenya agar saya bisa load data table tersebut jika saya klik salah satu optionnya.
Saya coba script di bawah tidak hasilnya error, dan setiap box isinya #Name?
Private Sub Fr_pilih_AfterUpdate()
Select Case Fr_pilih.Value
Case 1
Me.RecordSource = tbl_A
Case 2
Me.RecordSource = tbl_B
Case 3
Me.RecordSource = tbl_C
End Select
Me.Refresh
End Sub
Mohon masukkannya dari rekan2 semua.
Regards
Yasman David
PMA QS – ECM – Chevron Pacific Indonesia
RekindWorleyParsons
Tel: +62 765 99 3049| Mob +62 852 7160 9330| GMT +07
RW Office 2 – Ex Training Gate 2 - | Duri 28884 Indonesia | PT.RekindWorleyParsons
*** WORLEYPARSONS GROUP NOTICE *** "This email is confidential. If you are not the intended recipient, you must not disclose or use the information contained in it. If you have received this email in error, please notify us immediately by return email and delete the email and any attachments. Any personal views or opinions expressed by the writer may not necessarily reflect the views or opinions of any company in the WorleyParsons Group of Companies."
Posted by: "David, Yasman (ECM - RIAU)" <Yasman.David@WorleyParsons.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar