Any ideas on how I can pull records from a query within a date range? Each record has a date stamp and I would like to be able to put the start and end dates into text boxes on a form and return the results in the query.

Never Mind I found the answer. I put the search condition within the query instead of the form and it works great thanks.

You can use VBA to pull the value of the form textboxes into variables (i.e. dteStart, dteEnd) and create a query such as:

"SELECT * " & _
"FROM tbl " & _
"WHERE tbl.TimeStamp >= #" & dteStart & "# AND tbl.TimeStamp <= #" & dteEnd & "# ;"

Ah sweet! thanks for the reply it is nice to find other ways to do things. You never know when you will need it. I will play around with this method as well and see which one works out better for me. THANKS !!