Combo Box Control Source ? ? ?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Dodge Brown

    Combo Box Control Source ? ? ?

    Hi All


    I have a form which has a Datasource of "Table X" and 2 Child Sub-Forms
    linked to 'Customer' on "Table X".

    I am currently using a unbound text box to display 'Customer Name' and the
    navigation arrows to scroll through.

    How can I Use a Combo Box to Select 'Customer' on the Form for the 2
    Sub-Forms ? ? ?


    Any Help would be Greatly appreciated.


    Thanks in Advance

    Dodge


  • Larry  Linson

    #2
    Re: Combo Box Control Source ? ? ?

    If you select the third option in the Combo Box Wizard's first dialog box,
    it will generate such a Combo Box and the necessary VBA code _for_ you.

    Larry Linson
    Microsoft Access MVP

    "Dodge Brown" <dodge_brown@ho tmail.com> wrote in message
    news:3fb1349e$0 $3345$cc9e4d1f@ news.dial.pipex .com...[color=blue]
    > Hi All
    >
    >
    > I have a form which has a Datasource of "Table X" and 2 Child Sub-Forms
    > linked to 'Customer' on "Table X".
    >
    > I am currently using a unbound text box to display 'Customer Name' and the
    > navigation arrows to scroll through.
    >
    > How can I Use a Combo Box to Select 'Customer' on the Form for the 2
    > Sub-Forms ? ? ?
    >
    >
    > Any Help would be Greatly appreciated.
    >
    >
    > Thanks in Advance
    >
    > Dodge
    >
    >[/color]


    Comment

    Working...