Problem med filter på formular

me.filterOn = False

Prøver lige

Virkede ikke. Præcis hvor skal sætningen indsættes?

where are you using the Access filter?

I underformularen "frmBrancheSub"

Can you send the dB to eksperten@santhell.dk? I think I need to see how you rusing the filter etc. before I can say exactly!

Jeg sender den lidt senere, jeg bliver lige nødt til at korte den lidt ned.

Ok, and if you compact it then it should fill so much.

If its too late then I will maybe look first tomorrow.

Sendt

OK

OK, I have sent you an answer but just for the record

Change your code to this.

Private Sub tglFiltrerEfterMarkering_Click()

    If tglFiltrerEfterMarkering = True Then
   
        Me.frmBrancheSub.SetFocus
       
        DoCmd.RunCommand acCmdFilterBySelection
    Else
       
        Me.frmBrancheSub.Form.RecordSource = "Medlemmer Forespørgsel2"
        DoCmd.RunCommand acCmdRemoveFilterSort

    End If
   
    Me.frmBrancheSub.Form.Requery
   
    txtAktuel.Requery
   
End Sub


This line is added, just to make sure that the recordseource is as it was!

Mange tak for hjælpen.
PS. jeg fik ingen mail  så det var godt at du skrev koden her

Ok, it will maybe arrive tomorrow, and thanks :o)