Hi,

I am trying to display information in a grid which is being pulled from a database. However I want be be able to prompt the user to input the date they want to display when the form opens. I have two dates to search from, [to_date] and [from_date] and would like to do the equivalent of a "Between [to_date] and [from_date]" like you can do in access to open all records which fall inbetween those dates. I would be most gratfull for help to any part of this problem.

Many Thanks