Welcome to SPN

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

Sign Up Now!

Populate a field based on another table.

Discussion in 'Information Technology' started by Keith, Nov 9, 2005.

  1. Keith

    Keith
    Expand Collapse
    Guest

    I have a form with a sub form attached. I need three fields to be
    populated in the main form to allow a link to be made to the sub form.
    One of these fields is a Rep ID code. In another form I have a simple
    list of reps, their ID code and a tick box to say who the user is (only
    one tick is permitted so only one Rep can be selected).

    How can I get my main form to lookup the smaller table see who the rep
    is and populate the Rep ID field every time I add a new record?
     
  2. Loading...


  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Tue, 08 Nov 2005 15:30:54 +0000, Keith <keith@dolby-ltd.co.uk>
    wrote:

    >I have a form with a sub form attached. I need three fields to be
    >populated in the main form to allow a link to be made to the sub form.
    >One of these fields is a Rep ID code. In another form I have a simple
    >list of reps, their ID code and a tick box to say who the user is (only
    >one tick is permitted so only one Rep can be selected).
    >
    >How can I get my main form to lookup the smaller table see who the rep
    >is and populate the Rep ID field every time I add a new record?


    The simplest way would be to put a Combo Box based on the Reps table
    on your form.

    Note that the "another form" is an unnecessary complication. Just use
    a combo box or a listbox right on your mainform; you can even use its
    name as one of the three fields in the Master Link Fields property of
    the subform to automate the link.

    John W. Vinson[MVP]
     

Share This Page