How to Use Reference Expressions to Get Form Values in MS Access

Using expressions to reference your forms and controls is one of the more important skills you will need to learn to build applications in Microsoft Access. By using references, you can get values from one form and put them on another, use values from a form as criteria in a query, do calculations between forms, and lots of other cool stuff. So, learning this will really help you to program great applications in Access. Let's go!
Related Videos:
How to Use a Pass Through Query in MS Access - SQL Server Example
• How to Use a Pass Thro...
How to Simulate Lag and Lead Window Functions
• How to Simulate Lag an...
How to Filter by Month in MS Access Queries, Forms, and Reports
• How to Filter by Month...
How to Use Reference Expressions to Get Form Values in MS Access
You are watching this video now!
How to Create String Aggregates in Microsoft Access
• How to Create String A...
Interested in transforming your career or finding your next gig?
system.billzon...
Needing to hire technical resources for your project? Get the best:
www.toptal.com...
Want to get access to premium content made just for you and have a chat with me? Find me on Patreon :
/ mackenziedataengineering
Demo of my BZ RDP Cloaker:
www.patreon.co...
Want to work with me 1:1? Contact me today and book your free 20 min consultation!
Contact form you can find at www.mackenziema...
Follow me on social media:
/ mackenziedataanalytics
/ seamacke
/ seamacke
/ seamacke
/ psmackenzie
Get Microsoft Office including Access:
click.linksyne...
Got a KZbin Channel? I use TubeBuddy, it is awesome. Give it a try:
www.tubebuddy....
#msaccess #vba #dataengineering

[@seanmackenziedataengineering]

Ever wonder how to get a value off of a form, to use somewhere else?

[@interestingamerican3100]

Commenting for the algorithm. Thank you for covering this topic!

[@seanmackenziedataengineering]

Thanks again! I've got a good one coming tomorrow.. stay tuned.

[@jermainebuendia4312]

Hello sir! May I ask how to contact you? I just have a few questions regarding my rfid attendance system. Thank you!

[@seanmackenziedataengineering]

Check out my email in my profile!

[@eyribalt99]

Here with your monthly reminder the intro music is very distracting ;-)

[@seanmackenziedataengineering]

Noted! I'll turn it down. thanks!

[@RungeCarl]

Great Video

[@seanmackenziedataengineering]

Thanks!

[@imstevemcqueen]

I have a report with specific data on it using Form!frmName!frmField in underlying query used as rec source criteria...problem: sometimes when I print the report every record prints...even though only one shows up in prnt preview. Tried opening report using docmd.openrpt (filter) and all recs still print *sometimes*. Works 90% of time. Signed perplexed

[@seanmackenziedataengineering]

That's a doozy! I've been trying to think of what it might be, because I know I had this issue before (a looong time ago). You may want to just set the query SQL via code. Something like: strSQL = "Select * From MyTable Where frmField = '" & Forms!frmName!frmField & "'" Set qry = CurrentDb.QueryDefs("qryMyQuery") qry.SQL = strSQL qrySQL.Save DoCmd.OpenReport ..... Make sure the report recordsource is qryMyQuery.