Re: [belajar-access] Membuat combo box yang terpilih lebih dari satu

 

Coba gunakan script ini:

Combo6.RowSource = "select field1, field2 from sekolah" _
& " where kec_id=" & Combo5.Column(0) _
& " and kab_id=" & Combo4.Column(0)"

--------------------------------------------
On Mon, 14/7/14, him mah himmah.mlg@gmail.com [belajar-access] <belajar-access@yahoogroups.com> wrote:

Subject: [belajar-access] Membuat combo box yang terpilih lebih dari satu
To: belajar-access@yahoogroups.com
Date: Monday, 14 July, 2014, 1:43 PM


 









Assalamu'alaikum Wr. Wb.



mau tanya tentang combobox yang fungsinya seperti filter

biasayanya untk combo box yang bisa kita pilih kan cuma satu
parameter

saja. bisa ngga yang dipilih itu lebih dari satu, misal
kalau isi

combo box itu nama buah kita bisa memilih 2, anggur sama
durian



terima kasih











#yiv8659285813 #yiv8659285813 --
#yiv8659285813ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv8659285813 #yiv8659285813ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv8659285813 #yiv8659285813ygrp-mkp #yiv8659285813hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv8659285813 #yiv8659285813ygrp-mkp #yiv8659285813ads {
margin-bottom:10px;}

#yiv8659285813 #yiv8659285813ygrp-mkp .yiv8659285813ad {
padding:0 0;}

#yiv8659285813 #yiv8659285813ygrp-mkp .yiv8659285813ad p {
margin:0;}

#yiv8659285813 #yiv8659285813ygrp-mkp .yiv8659285813ad a {
color:#0000ff;text-decoration:none;}
#yiv8659285813 #yiv8659285813ygrp-sponsor
#yiv8659285813ygrp-lc {
font-family:Arial;}

#yiv8659285813 #yiv8659285813ygrp-sponsor
#yiv8659285813ygrp-lc #yiv8659285813hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv8659285813 #yiv8659285813ygrp-sponsor
#yiv8659285813ygrp-lc .yiv8659285813ad {
margin-bottom:10px;padding:0 0;}

#yiv8659285813 #yiv8659285813actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv8659285813 #yiv8659285813activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv8659285813 #yiv8659285813activity span {
font-weight:700;}

#yiv8659285813 #yiv8659285813activity span:first-child {
text-transform:uppercase;}

#yiv8659285813 #yiv8659285813activity span a {
color:#5085b6;text-decoration:none;}

#yiv8659285813 #yiv8659285813activity span span {
color:#ff7900;}

#yiv8659285813 #yiv8659285813activity span
.yiv8659285813underline {
text-decoration:underline;}

#yiv8659285813 .yiv8659285813attach {

clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv8659285813 .yiv8659285813attach div a {
text-decoration:none;}

#yiv8659285813 .yiv8659285813attach img {
border:none;padding-right:5px;}

#yiv8659285813 .yiv8659285813attach label {
display:block;margin-bottom:5px;}

#yiv8659285813 .yiv8659285813attach label a {
text-decoration:none;}

#yiv8659285813 blockquote {
margin:0 0 0 4px;}

#yiv8659285813 .yiv8659285813bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv8659285813 .yiv8659285813bold a {
text-decoration:none;}

#yiv8659285813 dd.yiv8659285813last p a {
font-family:Verdana;font-weight:700;}

#yiv8659285813 dd.yiv8659285813last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv8659285813 dd.yiv8659285813last p
span.yiv8659285813yshortcuts {
margin-right:0;}

#yiv8659285813 div.yiv8659285813attach-table div div a {
text-decoration:none;}

#yiv8659285813 div.yiv8659285813attach-table {
width:400px;}

#yiv8659285813 div.yiv8659285813file-title a, #yiv8659285813
div.yiv8659285813file-title a:active, #yiv8659285813
div.yiv8659285813file-title a:hover, #yiv8659285813

div.yiv8659285813file-title a:visited {
text-decoration:none;}

#yiv8659285813 div.yiv8659285813photo-title a,
#yiv8659285813 div.yiv8659285813photo-title a:active,
#yiv8659285813 div.yiv8659285813photo-title a:hover,
#yiv8659285813 div.yiv8659285813photo-title a:visited {
text-decoration:none;}

#yiv8659285813 div#yiv8659285813ygrp-mlmsg
#yiv8659285813ygrp-msg p a span.yiv8659285813yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv8659285813 .yiv8659285813green {
color:#628c2a;}

#yiv8659285813 .yiv8659285813MsoNormal {
margin:0 0 0 0;}

#yiv8659285813 o {
font-size:0;}

#yiv8659285813 #yiv8659285813photos div {
float:left;width:72px;}

#yiv8659285813 #yiv8659285813photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv8659285813 #yiv8659285813photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv8659285813 #yiv8659285813reco-category {
font-size:77%;}

#yiv8659285813 #yiv8659285813reco-desc {
font-size:77%;}

#yiv8659285813 .yiv8659285813replbq {
margin:4px;}

#yiv8659285813 #yiv8659285813ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv8659285813 #yiv8659285813ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv8659285813 #yiv8659285813ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv8659285813 #yiv8659285813ygrp-mlmsg select,
#yiv8659285813 input, #yiv8659285813 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv8659285813 #yiv8659285813ygrp-mlmsg pre, #yiv8659285813
code {
font:115% monospace;}

#yiv8659285813 #yiv8659285813ygrp-mlmsg * {
line-height:1.22em;}

#yiv8659285813 #yiv8659285813ygrp-mlmsg #yiv8659285813logo {
padding-bottom:10px;}


#yiv8659285813 #yiv8659285813ygrp-msg p a {
font-family:Verdana;}

#yiv8659285813 #yiv8659285813ygrp-msg
p#yiv8659285813attach-count span {
color:#1E66AE;font-weight:700;}

#yiv8659285813 #yiv8659285813ygrp-reco
#yiv8659285813reco-head {
color:#ff7900;font-weight:700;}

#yiv8659285813 #yiv8659285813ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv8659285813 #yiv8659285813ygrp-sponsor #yiv8659285813ov
li a {
font-size:130%;text-decoration:none;}

#yiv8659285813 #yiv8659285813ygrp-sponsor #yiv8659285813ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv8659285813 #yiv8659285813ygrp-sponsor #yiv8659285813ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv8659285813 #yiv8659285813ygrp-text {
font-family:Georgia;}

#yiv8659285813 #yiv8659285813ygrp-text p {
margin:0 0 1em 0;}

#yiv8659285813 #yiv8659285813ygrp-text tt {
font-size:120%;}

#yiv8659285813 #yiv8659285813ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv8659285813

__._,_.___

---

Posted by: hari yanto <har_i20002000@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

---

Yahoo Groups

Control your view and sort preferences per Yahoo Group

You can now control your default Sort & View Preferences for Conversations, Photos and Files in the membership settings page.

---

SPAM IS PROHIBITED

Visit Your Group

• New Members 6

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___