How to rid of Enter Parameter Value

[vangx222]

I'm not sure if anyone can help me with this without knowing my database, but I just thought I'd give it a shot.

I used the command button wizard to help look up a specific record on another form (called MAINfrm) based on the information in my current form (called frmFIND). On click, it works perfectly fine EXCEPT before it directs me to the correct record in the MAINfrm form, an "Enter Parameter Value" message pops up. The value it is asking for is an ID that's in one of the subforms in the MAINfrm I plan to open.

My question is, how would I get rid of this? I don't even need to enter a value in and it still works fine. Could anyone give some suggestions on what I can check?

btw, here's the code I currently have for it:

Private Sub OpenFRM_Click()
On Error GoTo Err_OpenFRM_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "MAINfrm"

stLinkCriteria = "[FirstName]=" & "'" & Me![FirstName] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_OpenFRM_Click:
Exit Sub

Err_OpenFRM_Click:
MsgBox Err.Description
Resume Exit_OpenFRM_Click

End Sub

 

[Remou]

Do you have the same problem when you open MAINfrm manually?

 

[vangx222]

Remou,
No. It opens fine and does not ask for anything.

 

[Remou]

Is there any code on the form that is opened? Have you tried this with a stripped down version of the form? Remember that the subforms load first, which can cause problems.

 

[vangx222]

Remou,

I created a second copy of the database and deleted the subform that it had been asking me to enter a parameter value. Once I did this, that message did not appear anymore.

The subform that it had been asking for a value is a subform within a subform, is this why it is creating some issue? The value it's asking for is the ID value of the subform within a subform.

For example,
I have a [MAINfrm] and within that [MAINfrm] there's a tab form (but is not a subform) and within one of those tabs I have a subform called [subtabSensory] AND WITHIN that subform [subtabSensory] I also have another subform called [subVibrations] which is a tab form also. The ID value it's asking for is the ID from a subform in the [subVibrations] subform.

It's a tab form within a tab form with subforms. I know this is really confusing but if you draw it out it should make sense, I hope

Thank you so much for your assistance.

 

[vangx222]

[highlight]Nevermind.[/highlight] I found the problem. I had that subtabSensory form Order By... an ID. That's why. After removing it then it stopped asking for it.

Thank so much for your assistance though.