Passing StartDate EndDate from a form to a query

[michaelb]

Hello All,



I want to select records from a table by a date range. In the query I am using: between [Enter Start Date] and [Enter Ending Date] in the criteria for the date field. The result is two Parameter boxes appear asking for the dates. Is there a way to pass the StartDate and EndDate to the criteria from a combo box. This would eliminate the Parameter boxes.

Thank you for you help,

michaelb

[RuralGuy]

You can use the Forms collection to fetch the value.
Forms.YourOpenFormName.StartDateControlName
...using your values of course.

[michaelb]

Thank you for your help.
I see where Forms.MyOpenFormName.StartDateControlName will work to give me a StartDate. I don't see how to get the EndDate using the same field in the criteria of the query. In the past I used the Between/And so I could enter both. How do get both using a forms collection?


Thanks

[RuralGuy]

How about Forms.MyOpenFormName.EndDateControlName

[michaelb]

Thanks again Rural Guy.
I didnot know that I could use the Forms Collection with the (Between/And) in the criteria. It worked...

[RuralGuy]

Excellent! Glad we could help. Are you ready to use the Thread Tools at the top of the thread and mark this thread as Solved?