I have designed the query I need, however, I can't seem to get the query's results to show in form view, they keep showing up in table view, the initial form is fine, but after running the query the results keep showing in data sheet view. any suggestions?

go to design veiw of the form and set the form property "Default" to "Single Form" or "Continuous Forms," but not "DataSheet."

Thanks, I tried that but it's still coming up the same.

Are you running the form or the query?
Run the form, but base the form on your query, not the table. When the form opens the query will be run, and your dataset will be pushed into the form as a result.

thanks, it works now!

Glad to hear it.