I have a subform with a Combo Box that needs to display a years fields for a particular SSN (selected from another Combo Box). For example my table, training history, has the years 2001 - 2002 - 2003 for all SSNs. SSN 111111111 may only have a history record for 2002 and that's all I want to display in my Combo Box, but I get all the years. I need to lookup the training history record for the SSN on the screen. Training year and SSN are both in the training history table.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Values for a Combo Box
- Thread starter jaggar
- Start date
You could make your combo box based on a query which has criteria bound to the SSN subform. When the user selects an SSN (After Update Event) you requery the combo box. I've used this technique several with good results. The tricky part is referencing the subform from the query. The syntax has to be just right to work. Hope this helps
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question