Show Dates for the Month via a form and filter the query based on Form

[CSP12345]

Ok I have a Query and a form, in the query I have dates of next service eg, "29-Mar-2015" and I need to be able to type in a text field in the form eg"Mar-2015" and filter all the results in the query.

Does that make sense?

 

[ranman256]

Put 2 text boxes on form...txtStartDate, txtEndDate. (name them in properties, other tab, name)

in your query set the criteria to
[DateOfEvent] between forms!frmRpts!txtSTartDate and forms!frmRpts!txtEndDate

 

[strive4peace]

adding on ... almost right

[DateOfEvent] between DateValue(forms!frmRpts!txtSTartDate) and DateValue(forms!frmRpts!txtEndDate)

since unbound textboxes are TEXT they must be converted

 

[CSP12345]

He strikes again, mate I thank you in advance for your guidance.

 

[strive4peace]

you're welcome -- did this work for you?