No problem.
I know at the beginning it seems like there's such a tangle of things you need to know. Each one by itself is easy, but the combination of everything seems daunting.
Folks with a lot of experience will write advice that is (to them) a single step, and to you it is a full day's fidgeting and learning.
Here's the code to go behind a button called cmdNext which would open the form frmNextFormname and close the current form.
You would use code like this only if you want that behavior based on a button click. On the other hand, if you set your app up as main form / subform, you wouldn't use this type of code.
Code:
Private Sub cmdNext_Click()
On Error GoTo Err_cmdNext_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmNextFormName"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.Close acForm, Me.Name
Exit_cmdNext_Click:
Exit Sub
Err_cmdNext_Click:
MsgBox Err.Description
Resume Exit_cmdNext_Click
End Sub
The significant command in this code is DoCmd.OpenForm, just like the significant command in the prior code excerpt was DoCmd.OpenReport. You can google DoCmd and find all the various options. As you would expect, there is one for Opening a Query called... can you guess?