Explore BrainMass
Share

Explore BrainMass

    Creating Search Table Based on Combo Box for Access Database

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    When 1 is selected for choice, check to see if the combination of 1 for choice and zip code exists. If combination exists, message "A primary location already exists for this zip code: If not, save code already in place.

    When 2 is selected for choice, check to see if the combination of 12for choice and zip code exists. If combination exists, message "A secondary location already exists for this zip code: If not, save code already in place.

    When 3 is selected for choice, Update Include field in table to "Out of Area".

    © BrainMass Inc. brainmass.com October 10, 2019, 3:13 am ad1c9bdddf
    https://brainmass.com/computer-science/searching/search-table-based-combo-box-access-database-411790

    Attachments

    Solution Preview

    Dear Student,
    Please find attached the update MS Access database. I have added a new form called frmSearchByOption. I have also ...

    Solution Summary

    Provides steps necessary to create the search table.

    $2.19