Ok, so after a little looking into it and after reading your suggestion. I was able to figure out a way to load up my form correctly and have it load without any errors coming up.
Code:
Private Sub Form_Load()
'Way this form is setup to load is that depending on if they copy from Items Table
'or if you just load this form up normally
'Define the variables here:
Dim StrYesorNo As String
'When the form loads we see that it is looking for
'a value for the variable which by defualt is set
'to "No"
StrYesorNo = "No"
'IF statement that defines how the form should load up and if values need to
'be copied over if coming from previous form (Items Table)
If StrYesorNo = "No" Then
'"No" = that it will open the form to see if anything was copied over
'since there isn't it will return a "No" value
DoCmd.OpenForm "CopyTestForm2", acNormal, , , acFormAdd
StrYesorNo = Forms!CopyTestForm2.Form!YesOrNo
DoCmd.Close acForm, "CopyTestForm2", acSaveNo
End If
If StrYesorNo = "Yes" Then
'"Yes" = that you have chosen to go about copying over data
'from the Items form and have chosen the correct publications
'will return a "Yes"
End If
End Sub
Here is my code that I used to get it working and also will marked this forum as solved!