How to display a queries results in a subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table called "Events". I also have a Form called "Events". I would
like to create another form that will filter EventDates. It was three Combo
Boxes Month, Day, year. I have a text box that will put all these values
together in a date format (Example: =[Combo19] & "/" & [Combo13] & "/" &
[Combo9]" I want a command button that you click on and will display the
events we have on that date in a subform on that same form.
 
you can filter the subform, from a command button on the main form, with VBA
code - something along the lines of

With Me.NameOfSubformControl.Form
.Filter = "EventDate = #" & Me!TextboxDate & "#"
.FilterOn = True
End With

substitute the correct names of the subform control, the event date field,
and the textbox control that combines the three combo boxes into a date
format.

hth
 
Back
Top