Between dates

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

Guest

Hi, i'm having a problem.. hope someone can hel

I'm doing an event form that enables users to select a start date and an end date
All events that falls between these dates will be returned.
So far i have managed to do textboxes with calenders for 2 date boxes.
however i don't have a clue on how to go on further.
Any suggestions?
Btw, in the same form i also have a date textbox which displays the event date.

Thanks for any help!
 
You can set this up using the two dates and the between function. Then place
the results in the forms filter.
Use the afterupdate event of the second date field to run this code:
Me.Filter = "[EventDate] Between #" & Me.FirstDate _
& "# And #" & Me.SecondDate & "#"
Me.FilterOn = True
 
Hm.. i failed to mention that my [event date] is in a subform

so where should i put the two date boxes? within the subform or outside or the subform

i did the afterupdate thing but nothing seemed to happen..

did i do anything wrong?
 
Back
Top