Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2008

    Unanswered: Need to update a field based on selected ControlSource

    I have a combobox that selects the customer and shows related information on that customer such as phone number, cc#, etc..

    now the trick is i need to allow the selected member to be added to the order information.

    For instance, the user selects the customer "Bob" and bobs information is displayed to check for accuracy. After the info is approved the user will continue to process his order. In order to do this I need the customer ID to be the same as the selected customer in the combobox.

    Then the user will proceed to fill out the order information, location, date, time, etc.

    How can I go about doing this?

    Thanks in advance

  2. #2
    Join Date
    Feb 2004
    Chicago, IL
    I would use the After Update event for the combobox. When the user selects a customerid, then have code in the event to set the customerID field to the one selected by the user.

    Sorry my answer is so vague, but if you want a more detailed answer then I suggest giving more details (especially names) about your form. For example, what is the name of the combo box? The name of the field that is bound to the CustomerID field? Are the two fields on the same form? If not, what are the names of the forms?

  3. #3
    Join Date
    Nov 2007
    Adelaide, South Australia
    Bind the combo box to the Customer ID field by setting the combo box's Control Source to Customer ID.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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