Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Posts
    4

    Unanswered: load multiple fields into parent from subform

    I'm building an application to assist in the dispatch of multiple vehicles into a city to pick up customers.

    The process of scheduling a trip begins when I pick a MemberID from a combo box. This loads the "static" data pertaining to the member into the tblTrips and I only need to add info for that day's trip.

    Example:
    Selecting MemberID from combo box automatically loads
    MemberFname
    MemberLname
    MedicalCondition
    PickupLoc
    ...

    I then enter
    TripNum
    TripTime
    TripDate
    Price
    DropLoc
    ...

    In a subform I display a list of previous trips for that same member (parent and child are linked by MemberID).

    What I would like to be able to do is select a previous trip from the subform by double clicking, and have all the data from the previous trip loaded into the parent form.

    I welcome any and all ideas.

  2. #2
    Join Date
    Apr 2002
    Posts
    139
    I would suggest you put a button on your subform, so that will show up on every subrecord.

    On clicking the selected button on the subform you will have to catch the info in the current subrecord. Code will look like:

    MemberFName (on main form) = [Forms]![MainForm]![SubForm].[Form]![MemberFName] (on sub form)

    Hope this helps

Posting Permissions

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