Change the RowSource for Yearcmb to:
SELECT FdrandYearID, YearRecorded FROM Yearly WHERE (((Yearly.[Name2ID])=[Forms]![Main]![Namescmb])) ORDER By YearRecorded;
Combo Box replacing navigation button (record selector)
VIP
Windows XP 
Access 2010 32bit
Change the RowSource for Yearcmb to:
SELECT FdrandYearID, YearRecorded FROM Yearly WHERE (((Yearly.[Name2ID])=[Forms]![Main]![Namescmb])) ORDER By YearRecorded;
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Advanced Beginner
Windows Vista Access 2007
works like a charm! thanks for helping me through that I really appreciate all the help!
Record Navigation bar
form record selector not working
Does change event works with navigation button?
Posting Permissions
Reply With Quote