REmoving auto form filter on dbl clk event?

**d9pierce1** · 03-31-2019, 04:36 PM

Hi all,
I have a list box that has a dblclk event to open form to go to specific record. when this happens it filters the form, how do i unfilter this without having to click? I just want it to go to that record.

Code:

Private Sub PartnerLst_DblClick(Cancel As Integer)
DoCmd.OpenForm "CompanyFrm", , , "CompanyID= " & Me.PartnerLst.Column(1) & " "
End Sub

**June7** · 03-31-2019, 04:59 PM

If you simply unfilter, focus will move to first record.

I would pass criteria to the opening form via OpenArgs and code behind that form goes to record using RecordsetClone, FindFirst, Bookmarks.

Is listbox UNBOUND?

**d9pierce1** · 03-31-2019, 05:10 PM

Hi,
ListBox is unbound populated by qry. with a criteria of [Forms]![CompanyFrm]![CompanyID]

**d9pierce1** · 03-31-2019, 05:17 PM

Company - Copy.zip
Here is a copy of the db
Thanks

**June7** · 03-31-2019, 07:13 PM

CompanyFrm is already open so code to open itself makes no sense.

The listbox lists partners associated with the main form record - you want to search for CompanyID that matches the PartnerID on main form and therefore see that partner's partners?

Code:

Private Sub PartnerLst_DblClick(Cancel As Integer)
With Me.RecordsetClone
     .FindFirst "CompanyID=" & Me.PartnerLst.Column(1)
     If Not .NoMatch Then Me.Bookmark = .Bookmark
End With
End Sub

**d9pierce1** · 03-31-2019, 07:28 PM

thank you,
Again!

REmoving auto form filter on dbl clk event?

Thread Tools

REmoving auto form filter on dbl clk event?

Similar Threads

Combo Box Auto Filtering @ Form Load to filter SubForm!

AfterUpdate() Event To Filter Sub Form

On Click event filter By checkbox = True

auto fill event procedure

auto running a delete query onclose() event

Posting Permissions