Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Combo box in subform repeating

Discussion in 'Information Technology' started by Kevin, Jul 28, 2006.

  1. Kevin

    Kevin
    Expand Collapse
    Guest

    I have a subform displaying the multiple child records for the parent record
    in the form. There is a combo box displaying values from a third (lookup)
    table. When a value is chosen from the combo box in any of the child
    records, all the values for that same field change in every child record.

    How do I build this subform so the user can choose a distinct value for each
    of the child records? What am I doing wrong?

    TIA

    Kevin D
     
  2. Loading...


  3. strive4peace

    strive4peace
    Expand Collapse
    Guest

    Re: Combo box in subform repeating -- ControlSource

    Hi Kevin,

    sounds like you need to make your control bound... fill out
    the ControlSource in the property sheet -- it needs to be
    one of the fields in your table if you want to be able to
    change it.

    If you just want to display something different on every
    row, put the calculation in the underlying recordset



    Warm Regards,
    Crystal
    Microsoft Access MVP 2006

    *
    Have an awesome day ;)

    remote programming and training
    strive4peace2006 at yahoo.com

    *

    Kevin wrote:
    > I have a subform displaying the multiple child records for the parent record
    > in the form. There is a combo box displaying values from a third (lookup)
    > table. When a value is chosen from the combo box in any of the child
    > records, all the values for that same field change in every child record.
    >
    > How do I build this subform so the user can choose a distinct value for each
    > of the child records? What am I doing wrong?
    >
    > TIA
    >
    > Kevin D
     

Share This Page