Results 1 to 3 of 3
  1. #1
    DocBec is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2019

    create a lookup on multiple fields prior to creating new record

    I'm new to access and need help on this. I created a crew database and want to find out if a new entry may already be there. (They change names, but may use the same tax id, email address, contact name, phone number or postal address)

    I want to create a form where I can enter 1 up to 5 of the previous elements and click a button to check if any of them are already present.
    Additionally, I'd like to save time by using what I already typed to create a new record if no duplicates are present.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    The Great Land
    For search utility, review

    Otherwise, enter data into bound controls and use code behind each input control that does lookup for that single or multiple values. Code in the example can be adapted.
    How to attach file: To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    DocBec is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2019
    Thank you very much!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 08-29-2018, 04:42 AM
  2. Replies: 21
    Last Post: 08-28-2018, 02:53 PM
  3. Creating a record lookup form
    By joecamel9166 in forum Access
    Replies: 3
    Last Post: 05-23-2016, 01:34 PM
  4. Lookup multiple fields
    By deemat in forum Queries
    Replies: 9
    Last Post: 08-28-2015, 01:06 PM
  5. Replies: 7
    Last Post: 11-18-2013, 02:38 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums - Senior Forums