Get a Value from an Open Form in Microsoft Access using Forms!FormName!FieldName Notation

In this video, you will learn how to get a value from another 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?

BONUS FOR MEMBERS:
Silver Members and up get access to an Extended Cut of this video. 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.

MEMBERS VIDEO:

BECOME A MEMBER:

LEARN MORE:

LINKS:

COURSES:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

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

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[DrRojeeh]

Very very very Informative and brilliant, ,i have been searching high and low for a couple of days to find this solution

[jessfoster]

I get a #name? error when my form is not open and I enter a new record. I'd like it be blank if not opened from the form like Richard said- what am I doing wrong? Fields match exactly. Does work when I add the record with form open.

[ammoodi]

Dear Richard : How can I get a value from an open query and make it a value of a field in an open form ?

[GregandJoanKoskela]

I've created a button in "Form 1" to open "Form 2" with an employee ID copied to "Form 2" and it works great. However, I use a switchboard that displays "Form 1" and I get #Name? in the ID field in "Form 2" instead of the employee ID. Is it even possible to do this from the "Form 1" within the switchboard? Can I set it up so it will work from either "Form 1" or from "Form 1" within the Switchboard?

[richardmeborg]

Hi Richard. I have a database where I have a Table, Query and a Form called Company, which is information of my own company. And of courseI have severalother forms as well. I would like to make it automaically that my company name will be shown in all other forms as a hedingfor the form. The Form Company is not connected to any other forms. Is there a way tomake this to happen?
Thank you

[dodomak]

This is exactly what I need but it doesn't work for nested continuous forms, right?

[aimenbaig]

what about getting multiple values instead of one?

[GermanCoder]

How to get input text box value of current opened form?