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.