Group:  Microsoft Access ยป microsoft.public.access
Thread: Unbound Cascading Combo Boxes

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Unbound Cascading Combo Boxes
cathywoodford[ at ]personainternet.com 20.09.2006 18:04:09
Hi. How do I go about coding 2 unbound combo boxes with the 2nd items
being based on the first selection? I have a cboInstrument and a
cboSpecificInstrument - cboSpecificInstrument should be based on the
selection from cboInstrument?

Thanks,
Cathy

Re: Unbound Cascading Combo Boxes
"Roger Carlson" <NO-Roger.J.Carlson-SPAM[ at ]gmail.com> 20.09.2006 18:22:37
On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "CascadingComboBoxes.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L


<cathywoodford[ at ]personainternet.com> wrote in message
news:1158775449.246071.84550[ at ]b28g2000cwb.googlegroups.com...
[Quoted Text]
> Hi. How do I go about coding 2 unbound combo boxes with the 2nd items
> being based on the first selection? I have a cboInstrument and a
> cboSpecificInstrument - cboSpecificInstrument should be based on the
> selection from cboInstrument?
>
> Thanks,
> Cathy
>


Re: Unbound Cascading Combo Boxes
cathywoodford[ at ]personainternet.com 21.09.2006 14:24:01
Hi Roger...maybe I'm looking at this wrong but this only shows how to
use it with a combo box that is bound - both my combos are unbound?

Cathy
Roger Carlson wrote:
[Quoted Text]
> On my website (www.rogersaccesslibrary.com), is a small Access database
> sample called "CascadingComboBoxes.mdb" which illustrates how to do this.
>
> --
> --Roger Carlson
> MS Access MVP
> Access Database Samples: www.rogersaccesslibrary.com
> Want answers to your Access questions in your Email?
> Free subscription:
> http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
>
>
> <cathywoodford[ at ]personainternet.com> wrote in message
> news:1158775449.246071.84550[ at ]b28g2000cwb.googlegroups.com...
> > Hi. How do I go about coding 2 unbound combo boxes with the 2nd items
> > being based on the first selection? I have a cboInstrument and a
> > cboSpecificInstrument - cboSpecificInstrument should be based on the
> > selection from cboInstrument?
> >
> > Thanks,
> > Cathy
> >

Re: Unbound Cascading Combo Boxes
"Rick Brandt" <rickbrandt2[ at ]hotmail.com> 21.09.2006 15:02:07
cathywoodford[ at ]personainternet.com wrote:
[Quoted Text]
> Hi Roger...maybe I'm looking at this wrong but this only shows how to
> use it with a combo box that is bound - both my combos are unbound?

The cascading aspect of "cascading ComboBoxes" is all due to their RowSource
properties. This has nothing to do with whether they are bound are not
which is determined by their ControlSource properties.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net