Thread: Update one form based on another
2012-05-10, 20:07 #1
- Join Date
- May 2012
- Thanked 0 Times in 0 Posts
Update one form based on another
In access 2007 I want to update my Subform based upon entry in one text field in my main form. Right now the subform won't update unless i close the and reopen it or go to the next record and then come back.
I have tried entering the following in the After Update event control for the text box
With this I get the error that the object "forms!subformname" cannot be found. I am typing the subform name exactly as it is seen in the objects menu or source object field in the properties of the subform.
Any ideas how to get the subform to automatically update with the new records after entry in my main form?
Thanks for the help!
Last edited by redbaron508; 2012-05-10 at 20:48.
Subscribe to our Windows Secrets Newsletter - It's Free!
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!
2012-05-11, 04:08 #2
- Join Date
- Jun 2010
- Thanked 1,100 Times in 1,012 Posts
Welcome to the Lounge.
or with the longer syntax