Results 1 to 3 of 3
  1. #1
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Combo Box (2002)

    I have a combo box on a (Single) form that displays (in drop down) four columns:

    Name
    OfficePhone
    CellPhone
    Pager

    When a selection is made, the Name is displayed in the combo box.

    I also have a Continuous form (based on the same query) that displays this same Name, but in a text box. There is no access to the phone numbers. Is it possible to have three additional text boxes that will display the (underlying) phone numbers from the combo box?
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

  2. #2
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combo Box (2002)

    Bryan
    How is you single form related to your continuous form ?

    With a combo, you can display all it's data quite simply, example:
    cboContact which has 4 columns, 0 = Name, 1 = OfficePhone, 2 = CellPhone, 3 = Pager.

    Now it's quite easy to pull this info by creating 4 unbound text box's on your form.
    In the control source of each, you must relate to the column you need, ie

    (Text1) - (ControlSource) =cboContact.Column(0) to display the "Name"
    (Text2) - (ControlSource) =cboContact.Column(1) to display the "OfficePhone"
    (Text3) - (ControlSource) =cboContact.Column(2) to display the "CellPhone"
    (Text4) - (ControlSource) =cboContact.Column(3) to display the "Pager"

    Combo's columns start from numerical 0 (Zero)

    On the other hand, if the Cont..... form has the query behind it, Just add the relevant fields from the field selection list in design view .

  3. #3
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: Combo Box (2002)

    Dave:

    Not enough coffee this morning. I kept screwing up the syntax. Thanks for the input - it works perfectly!
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •