none
Updating via subform RRS feed

  • Question

  • I have a Customer Form which has two subforms - Salesperson and Division. It follows the structure:

    Customer Table

    ID

    CustomerName

    SalespersonID

    DivisionID

    Salesperson Table

    ID

    Initials

    FirstName

    LastName

    Division Table

    ID

    DivisionNumber

    DivisionName

    I have a Customer Form that has two subforms, one with the salesperson data that is linked to the salespersonId in customer table and one subform with division data that is linked to the divisionid in customer table

    Since the subforms can only have one record, I'd like to have a dropdown in the subform where the user can change the salesperson or division for a customer in the subform.  For the subforms, I use the link child/master fields.

    How do I set a field with a dropdown that changes the ID in the customer field?

    Thank you for your help

    Wednesday, December 11, 2019 3:58 AM

Answers

  • You should not change the SalesPersonID or DivisionID in the subforms, but on the main form. You can create combo boxes on the main form bound to those fields, with the SalesPerson and Division tables as Row Source. When the user selects an item, the corresponding subform will be updated automatically.

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by JHarding08 Wednesday, December 11, 2019 4:20 PM
    Wednesday, December 11, 2019 12:12 PM