Question of why Filter

[Les Blair]

When I press the cmd button and execute the following:

Dim stDocName As String
Dim stLinkCriteria As String
Dim intNum As String

DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenQuery "InsertNewSBDProspects", acViewNormal, acAdd
stDocName = "frmSBDProspects"
intNum = Me.txtCaseTrackNbr
stLinkCriteria = ([Case Track Nbr] = " & intNum & ")
DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormEdit

It add the new record to the table like it should and it opens the frmSBDProspects like it should but it puts a "Filtered" indicator on the bottom of the screen and does not return my screen that I want. When I right click on the "Find" button and press the remove Filter it than shows the screen I wanted. Why is the filter indicator even coming on and how do I stop it from coming on.

 

[odin1701]

You are filtering for stLinkCriteria by specifying it as criteria when opening the form.

 

[Les Blair]

In otherwords it is trying to find the record I requested?

When I clear the filter it opens the records I requested because the record in the last or first on the file. (dep on sort seq) but if there is more than one user I can I be sure I am opening the right record?