Re: Dependent Combo Boxes?
- From: "JICDB" <JICDB@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 20 May 2005 06:36:01 -0700
Works like a charm! Thanks so much for your help.
"Sandra Daigle" wrote:
> This is relatively easy to do. First, make sure that the description field
> is included in the rowsource query for your combobox. Then you will need to
> create a textbox with an expression as the ControlSource. Just drag a
> textbox control onto the form from the toolbox then in the controlsource
> property you will put the following, replacing cboMyCombo with the name of
> your combobox, and replacing 'n' with the field number in the query minus 1
> (the column property is indexed starting at 0).
>
> =cboMyCombo.column(n)
>
> If your description field is the 2nd field in the combo, then you'd put:
>
> =cboMyCombo.column(1)
>
>
> --
> Sandra Daigle [Microsoft Access MVP]
> Please post all replies to the newsgroup.
>
>
> JICDB wrote:
> > I have been scouring this website as well as another to find a
> > solution to my problem. After reading the posts regarding a
> > Dependent Combo box I wonder if this is what I need. (I have
> > excellent Microsoft skills but am a beginner in Access). I have a
> > table that contains 2 fields: a complaint code and a complaint
> > description for that code. I am creating a data base for our
> > customer service complaint line and this form is for data entry where
> > I want the user to type in the code (3 char) and in another field the
> > corresponding complaint description comes up without typing it. I
> > read in the Help screens in Access that I can set it up so that if
> > the code is typed in the description can be viewed but I want both to
> > appear. Any ideas on how this can be done? I appreciate any help I
> > can get.
>
>
>
.
- References:
- Dependent Combo Boxes?
- From: JICDB
- Re: Dependent Combo Boxes?
- From: Sandra Daigle
- Dependent Combo Boxes?
- Prev by Date: Re: Filtering with multiple combos problem
- Next by Date: RE: Add Record To Existing Table via VB code
- Previous by thread: Re: Dependent Combo Boxes?
- Next by thread: Re: Dependent Combo Boxes?
- Index(es):
Relevant Pages
|
