Clearing combo box

[Guest]

I am using the following code to open Form FrmJobs2 and go to a specific
record.

Private Sub txtInvNo_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stLinkCriteria As String
stLinkCriteria = "[Jobid]=" & Me.txtJobID
stDocName = "FrmJobs2"
DoCmd.OpenForm stDocName, , , stLinkCriteria, , acDialog
DoCmd.Close acForm, "FrmCollections", acSaveYes
Me.Requery
End Sub

If I then want to select a different job from the combo box on that form
(all jobs are listed), it does not let me select a different job. How can I
clear the "stLinkCriteria".
Thanks,

 

[ruralguy via AccessMonster.com]

The WhereCondition argument (your stLinkCriteria) applies a filter to the
next form. I prefer to pass the ID in the OpenArgs and use the OnLoad event
of the next form to locate the record with FindFirst.
I haven't tried it but maybe:
Me.FilterOn = False
Me.Filter = ""
will clear the filter.

I am using the following code to open Form FrmJobs2 and go to a specific
record.

Private Sub txtInvNo_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stLinkCriteria As String
stLinkCriteria = "[Jobid]=" & Me.txtJobID
stDocName = "FrmJobs2"
DoCmd.OpenForm stDocName, , , stLinkCriteria, , acDialog
DoCmd.Close acForm, "FrmCollections", acSaveYes
Me.Requery
End Sub

If I then want to select a different job from the combo box on that form
(all jobs are listed), it does not let me select a different job. How can I
clear the "stLinkCriteria".
Thanks,

 

[Guest]

I did not realize that this code was creating a filter.
Me.Filter = ""
did the trick
Interesting that you mention the openArgs to pass the ID on in the onload
event of the next form. That is probably the solution to my next problem. It
will put that into a new post. I try to work it out myself first.
Thanks

The WhereCondition argument (your stLinkCriteria) applies a filter to the
next form. I prefer to pass the ID in the OpenArgs and use the OnLoad event
of the next form to locate the record with FindFirst.
I haven't tried it but maybe:
Me.FilterOn = False
Me.Filter = ""
will clear the filter.

I am using the following code to open Form FrmJobs2 and go to a specific
record.

Private Sub txtInvNo_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stLinkCriteria As String
stLinkCriteria = "[Jobid]=" & Me.txtJobID
stDocName = "FrmJobs2"
DoCmd.OpenForm stDocName, , , stLinkCriteria, , acDialog
DoCmd.Close acForm, "FrmCollections", acSaveYes
Me.Requery
End Sub

If I then want to select a different job from the combo box on that form
(all jobs are listed), it does not let me select a different job. How can I
clear the "stLinkCriteria".
Thanks,