Unanswered: Filter Subform By Main Form Date Combo Box
Currently I have a main form w/ subform. In the main form, a user selects bond's serial number from a combo box and the subform displays the bond's returns for the months owned along with a start date (each month has its own start date). So if we owned a bond from January to March, it will display the three months' returns. I want to add two combo boxes (Beginning and End Date) so that I can filter the subform to only show a particular set of months' returns.
I have three tables right now: Cusips (lists each bond's serial number), CusipStartPK (lists the monthly returns for each serial number), and ParameterDates (list of four start dates--ie 13-01-01 for January, 13-02-01 for Feb, etc.) The main form and subform are linked via table relationship between Cusips and CusipStartPK.
I've tried parameter queries and vba codes from other threads but I can't get this to work. Any help would be greatly appreciated and I can answer any further questions.
First, I would not use comboboxes to select dates, just an unbound text box formatted for dates. In your subform I would put a criteria for the Date fields that are tied to the main forms StartDate and EndDate fields.
Then, in the StartDate and EndDate fields on your main form use the After Update events to requery your subform: Me.subformName.requery