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
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.