Showing query in a form and using filter

[rlan214]

so I have been working on this form for a while and I'm really a newb at this
maybe it easy maybe its not but i just couldn't figure this out
I'm so frustratated that I'm willing to pay(beer money for help)


well anyways I have this form

at the side you can see that there are 3 filters
1st has check box (check box is always checked) for the date
2nd check box for Target Location
3rd check box for ForkliftID1

I also don't know how to change the date format in my date
its in yyyymmdd format right now and I want it mmddyyyy

In the middle theres a blank, and thats where I wanted my
query to show

here's my query

 

[Calvin]

Use a subform to display your query by binding the form to your query, and set the forms Default View property to DataSheet.
You will also need a trigger of somekind to update your query, maybe an OnClick event or an AfterUpdate event.
You may find working with your query easier by using SQL instead of a saved query.