Kan man lytte til state af en form

Me.FilterOn = False

Try putting a toggle button on your form and then in the on click event (i think) you can use somethink like this tio swith the filter on and off

Me.FilterOn = Me.tglButton.Value

mugs hvor vil du sætte den værdi

jeg kan netop ikke lave en knap i formen, idet denne function
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 2, , acMenuVer70
Låser min form således jeg "kun" kan udfylde filterselections og så trykke applyfilter oppe i dropdown-menuerne

I have a button ona form which allows me to filter the form. Then once I have activated the filter I have another button on th eform to toggle between filtered/not filtered.

You cant us ethe toggle button because Access is still waiting for your to activate/cancel the filter from the menu.

If you wnat more control I would suggest you make your own filter system. See Thomas Jepsens example www.makeiteasy.dk under downloads (Filter og søgefunktion)

http://www.makeiteasy.dk/eksempler/DynamiskSøgefunktion.zip

Terry>> thnx, jeg har selv kodet en lignende function, men jeg vil gerne at brugeren i formen kan lave et filter og ikke skal over i et søge billede.

Kan det ikke være på andre måder, lever jeg med det, undrer mig bare at man ikke kan lave noget med denne

Private Sub Form_Filter(Cancel As Integer, FilterType As Integer)
    If FilterType = acFilterByForm Then
        Me.btnSearchFilter.Visible = True
       
       
    ElseIf FilterType = acFilterAdvanced Then
        MsgBox "Brug et andet filter bla bla bla"
              Cancel = True
    End If
End Sub

In Access 2007 and I alos think it was in previous versions, you can apply the filter using the mouses right button (shortcut menu) and then you can toggle the filter form the record selectors on the form