Discuss "DoCmd.ApplyFilter" in the Microsoft Access forum.

AOG123 · #1 (**permalink**) June 6th, 2008, 11:56 AM

Hi,..

I'm trying to add filters to a continuous form but don't want to change the undelying query,..

So i've tried using the DoCmd.ApplyFilter in the after update of a combo

Below is the closest i can get,.

when i say close at least it filters the records,.. but filters them all out

The example i'm using is simply filtering a text field field,.. the combo is in the form header.

DoCmd.ApplyFilter , ("fieldname= ' " & Combo.Value & " ' ")

Any ideas,.. i guess this will be something obvious

sbenj69 · #2 (**permalink**) June 6th, 2008, 12:00 PM

Say your combobox was me.combo18, after update, put this:

Code:

Dim mystr As String
Dim FltrStr As String

mystr = Nz(Me.Combo18, "")
FltrStr = "Fieldname ='" & mystr & "'"

DoCmd.ApplyFilter , FltrStr

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

The Following User Says Thank You to sbenj69 For This Useful Post:
AOG123 (June 6th, 2008)

Discuss "DoCmd.ApplyFilter" in the Microsoft Access forum.

Microsoft Access - Microsoft Access is a database for small to medium applications. Learn tips and tricks and best database practices here.