accessprogrammers.co.uk is a decent place but there are lots of different forums. Most of them expect you to put in most of the hard work though, so best to go at least with some examples of what you have done.
You can actually do most of this this without code if you are not comfortable doing this.
I'm assuming you are on Access 2007+. All you need to do to bind a query to a form is use the form wizard. This assumes one query per form by the way.
So go to the create tab on the ribbon and you will see "Form Wizard". Press this which will then open up a guide, basically select the specific query you want from the drop down, and the specific fields you need from the list boxes. This will automatically generate the form for you, name it something useful.
To open it from another form you need to create a button event. I would recommend doing this in code but again you don't have to. If you drag a command button to your main form, another wizard will open, select Form Operations from the list box and then open form and then point it to the form you previously created in the wizard.
This creates an event for you, so every time you click that button the form will open, which will populate itself based on the query you bound the form too.
Note: Just thought if you want to view this as a "table view" make sure that you set allow form view on the properties of the form where you bound the query to no, datasheet view should already be set to yes.
