Thread: Main Form/Subform Lookup (2007)
2008-06-09, 22:59 #1
- Join Date
- Aug 2002
- Minneapolis, MN, Minnesota
- Thanked 0 Times in 0 Posts
Main Form/Subform Lookup (2007)
I have a record lookup (a combo box which pulls its data from 2 tables that have a 1 to many relationship) on a form that has a subform with multiple records.
I would like to know what VBA code would I put in the combo box’s AfterUpdate event that would find the selected main form’s record and the selected subform’s record.Easy Access
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!
2008-06-09, 23:13 #2
- Join Date
- Mar 2002
- Thanked 16 Times in 16 Posts
Re: Main Form/Subform Lookup (2007)
See <post:=381,240>post 381,240</post:> for code and a sample database.