I have 4 Date and time picker controls on a form along with a subform. I want records to be displayed based on dates and times selected. I have 2 problems.
1) The date controls are working just fine, but I cannot seem to get the time controls to work. In the criteria section of my query I have:
>=[Forms]![Main]![StartTime] And <=[Forms]![Main]![EndTime]
Since this worked for the date, I thought it may work for the time. Obviously, I was wrong.
2) Is there any way I can have the records show up in the subform based on the user's selections? Currently, the only way I can get it to work is by using a command button to run the query. Once the button is clicked, the query is displayed instead of the records showing up in the subform.
Any help would be greatly appreciated!
Thank you,
Brandon
1) The date controls are working just fine, but I cannot seem to get the time controls to work. In the criteria section of my query I have:
>=[Forms]![Main]![StartTime] And <=[Forms]![Main]![EndTime]
Since this worked for the date, I thought it may work for the time. Obviously, I was wrong.
2) Is there any way I can have the records show up in the subform based on the user's selections? Currently, the only way I can get it to work is by using a command button to run the query. Once the button is clicked, the query is displayed instead of the records showing up in the subform.
Any help would be greatly appreciated!
Thank you,
Brandon