Get Value from a Form. Forms!FormName!FieldName

In this video, you will learn how to get a value from another open form in Microsoft Access. I will show you how to default a new order to the currently open customer.

Kole from Chandler, Arizona (a Platinum Member) asks: I'm using your Invoicing Template which is very helpful. Thank you. When you click to add a new invoice for a customer, is there any way to have the customer combo box automatically set to the currently open customer on the customer form?

Members

Members will learn a more elegant solution to check to see if the OrderID is null when the user starts entering a line item in the order detail form. If so, one will be automatically assigned. This will prevent an error message. Also, members will learn how to reference a value on a subform and some simple debugging with On Error Goto.

•  Extended Cut Video - Silver
•  Gold Member Template 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!

Syntax

• Fields on a single form: Forms!FormName!FieldName
• Fields on a subform: Forms!ParentFormName!SubFormName.Form!FieldName

Links

• Invoicing: https://599cd.com/Invoicing
• Bang v. Dot: https://599cd.com/BangDot
• Query Criteria: https://599cd.com/Criteria
• Default Value: https://599cd.com/DefaultValue
• Access Expert 2: https://599cd.com/ACX2

Learn More

• Value From Subform: https://599cd.com/ValueFromSubform

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

microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, Forms!CustomerF!CustomerID, Before Insert Event, Value from a Subform, Debugging, On Error Goto, Value from Subform, Check for OrderID, Forms!FormName!FieldName, .Form!, value from a different form, criteria from a form