I hope that someone out there has had this type of a problem before. I am using Access to recreate an database that was created in FoxPro. I have replicated all of the easy parts of the form and I now have hit a wall.



I wish to use the Date picker to choose a date. After choosing the date, I want a query to run and display the results of the information that matches the date in the subform. The only interaction I want the end user to have is to choose the date they want to look at. Also, I would like to have the date defaulted to the current day each time you open the form.

I am sure that I am asking a lot but I hope that someone else has an idea on what to do. I am losing my mind. :cry:

Thanks,
Jim