Troubleshoot Command Button that is Filtering the Form it is Opening

[Huddle]

I have a command button that opens a form. When it opens it is in filter mode even though the properties indicate no filter on load.



The command button is located on a tab, which I don't know that this should make a difference. I've looked in other places to see if any properties are set with a filter but I don't find any.

Any guess as to why it would be doing this?

[pbaldy]

What is the code behind the button?

[Huddle]

Private Sub ProjDetailCom_Click()
On Error GoTo Err_ProjDetailCom_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "SubForm_CM_Package"

stLinkCriteria = "[PK_Project_Num]=" & "'" & Me![PK_Project_Num] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_ProjDetailCom_Click:
Exit Sub
Err_ProjDetailCom_Click:
MsgBox Err.Description
Resume Exit_ProjDetailCom_Click

[pbaldy]

There you go. It's doing this:

BaldyWeb wherecondition

[Huddle]

I changed the code but am still getting the filter.


Private Sub ProjDetailCom_Click()
On Error GoTo Err_ProjDetailCom_Click
DoCmd.OpenForm "SubForm_CM_Package", , , "PK_Project_Num = '" & Me.PK_Project_Num & "'"
Exit_ProjDetailCom_Click:
Exit Sub
Err_ProjDetailCom_Click:
MsgBox Err.Description
Resume Exit_ProjDetailCom_Click

End Sub

[pbaldy]

You've simply eliminated the variable. If you don't want a filter:

DoCmd.OpenForm "SubForm_CM_Package"

[Huddle]

I guess I should clearify. I want it to open to a specific record, PK_Project_Num, but when it is filtered it is only bringing up a blank form. When I unfilter it it brings up the document.....light bulb.... I only have one record in there. It is bringing up all records when I unfilter it. For some reason it is not filtering to bring up the correct record.....ummm. Need to figure out why it isn't reading the variable.

[pbaldy]

Is the record saved at the point the code runs? Have you set a breakpoint and checked the value when the code runs?

[Huddle]

I'm going to have to redo how I'm doing this. It isn't going to work with multiple projects. Thanks for your help though. Sorry to waste your time.

[pbaldy]

No problem.

[always404]

Why not just set the filter to nothing right after opening it.
Like this:

Me.Filter = ""