Welcome to SPN

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

Sign Up Now!

Populate Subform

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

  1. Kevin

    Expand Collapse

    I have a table which handles a many-to-many relationship. I created a form
    with a combo box from each of the tables witht e many values, and capture the
    keys to put into the join table from those combo box choices (values are
    present and populated to variables for use). I created a subform, to display
    the values once created, and want to push the values from the combon box
    choice into the new record created.

    in other cases, I've caputred the input value into a variable, set focus on
    the subform and used Me.FieldName.Value = Variable. However, the fieldnames
    in the subform are not available, even though the focus is on the subform
    (cursor is sitting in the field I want to update). The fieldnames fromt he
    main form do show up when I type Me. I have no idea why the subform fields
    are not available to be populated.

    Any suggestions?


    Kevin D

Share This Page