Display query results in a form

[crwilliams]

New to access.

I am trying to allow end-users to only use buttons to navigate and display records in my database (so they don't know access is in the background) I have query that runs when they press a button but after they run it there is no way to get back to the main interface screen i.e. there is not a place to put another button and close the query. I was looking into creating a form to display the query results in datasheet view but it is not appearing the way I want. I inserted a subform and the results got better but I also do not like the way it displays because the user can see the subform, i.e formatting it is awful. Does anyone know of a relatively simple solution to get my data to display in the form so a user can view the results similar to datasheet view?

 

[JHB]

Change the subform's property "Default View" to "Datasheet"

 

[crwilliams]

I havee done that and it does absolutely nothing

 

[JHB]

Post your database with some sample data + info in which form the problem is.