[belajar-access] RE: Tanya Script vb option button

 

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 (1)

---

Yahoo Groups

Test Campaign

subject line for test

---

SPAM IS PROHIBITED

Visit Your Group

• New Members 3

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___