Combo box to select form's contents

N

Nick M

I have a table with a number of fields, one of which is called
"DateEffective". I have a form, in continuous view, which is built off this
table. There is a combo box in the Form Header, where the user can select a
particular "DateEffective". What I would like to have happen is the form to
then display only the records with the corresponding "Date Effective" to be
shown in the Details section. I could do this in a subform, I know, but for
the time being let's pretend this isn't an option. Does anyone have any idea
how to do this?

Much Thanks,
Nick
 
Top