Set Return Value After Using List Items Edit Form

In this Microsoft Access tutorial, I'm going to show you how to return the value that was just added or edited to the combo box you called the List Items Edit Form with, so that you don't have to scroll through the whole box to find it.

Willis from Juno Beach, Florida (a Platinum Member) asks: I love the video you did last week on the List Items Edit Form, however, is there anyway to get that new item you've just entered and set that value in the combo box you came from? As it is now, I have to type in a new value, close the Edit Form, and then scroll through the combo box to find it.

Members

Members will learn how to return a value to multiple calling forms. We'll add a default shipping method to our customer form, and you can now use both that and the order form to call the ShippingF List Items Edit Form and it will know where to return the value. 

•  Extended Cut Video - Silver
•  Database Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Links

• List Items Edit Form: https://599cd.com/ListItemsEditForm

Suggested Courses

• Access Beginner 8: https://599cd.com/ACB8
• Access Expert 4: https://599cd.com/ACX4

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, list items edit form set value, on unload event, on close event, default shipping method, return value to combo box, ms access list items edit form return value, editing value lists