Results 1 to 6 of 6
  1. #1
    need_help12 is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2012
    Posts
    58

    Form prompt when combobox returned multiple records

    Good morning. Relatively new to Access, and the build I'm doing needs to be very simplistic. In this case, I'm building a simple database to store vendor data and need to be able to retrieve this information from the table in which I store it.

    In this case, I've built a simple form "Vendor Search" which provides a combo-box to select the vendor you're looking for and it'll display the info accordingly. The issue I've run into is I have vendors at multiple locations, thus different data associated with each. Per this forum, I was able to remove the duplicates from the combo-box on this form, but I would like to add a prompt to bring it to the end-user's attention anytime their search returned multiple records.

    While I'm aware this is shown at the bottom of the form to indicate how many were returned, I can't assume my end-users will notice this.

    I've attached my dummy database to be more clear. In this dummy db, Vendor1 has multiple records, and I would like to better inform the end-user that multiple records are present.



    I appreciate any assistance anyone is willing to lend.
    Attached Files Attached Files

  2. #2
    TG_W is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    May 2010
    Location
    Manvel, TX
    Posts
    299
    3 Questions/Comments

    1. Is it important to only see one record at a time? If not, change the Default View to Continuous View in the Format tab in the Property Sheet.
    2. I would suggest moving your filtering criteria up into the Form Header section instead of the Detail section.
    3. Might I suggest dumping Macros and use VBA instead?

  3. #3
    need_help12 is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2012
    Posts
    58
    You can absolutely suggest it! Now whether or not I'm versed in VBA (which I'm not) is another question

  4. #4
    TG_W is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    May 2010
    Location
    Manvel, TX
    Posts
    299
    If you download the 2 databases I uploaded in the thread "Multiple Inventory Entry" and "Combo box with subform", it should give you what you need. I put some explanations as to what the code is doing in the "Multiple Inventory Entry" thread, which should help you understand some of the simple tasks like it seems you are looking to accomplish. The "Combo box with subform" thread shows the coding for a combo box or two combo boxes with multiple steps typed in.

    https://www.accessforums.net/showthr...x-with-subform
    https://www.accessforums.net/showthr...nventory-Entry

  5. #5
    need_help12 is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2012
    Posts
    58
    Ah, boom! Got exactly what I needed and it worked. Thanks, TG_W!

  6. #6
    TG_W is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    May 2010
    Location
    Manvel, TX
    Posts
    299
    You're welcome. Gald I could help!

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

Similar Threads

  1. User Prompt for multiple Files
    By ratherbgolfing in forum Programming
    Replies: 1
    Last Post: 01-31-2012, 03:38 PM
  2. Replies: 2
    Last Post: 05-26-2011, 12:15 PM
  3. Replies: 1
    Last Post: 04-12-2011, 05:19 PM
  4. Replies: 2
    Last Post: 08-17-2010, 10:54 AM
  5. Counting returned records in a query
    By johncob in forum Queries
    Replies: 0
    Last Post: 02-11-2009, 05:30 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