Turning off the filter using vba

[peterlee516]

Hi,

I have a vendor form with a list box displaying all the vendors along with more vendor description fields. Selecting the record on the list updates the form record.

When I open this vendor form from the main "projects" form it filters based on the vendor selected and opens the vendor form with that vendor showing up.

Once the user decides to select another vendor from the list box, I want to automatically turn off the filter so that any vendor selected from the list will be displayed.

I've tried the follwing with no sucess.

me.filter = null
me.filter = 0
me.filter = off

Thanks,
Peter

 

[Luka]

Me.Filter = False

 

[peterlee516]

Sorry.. I tried that too. It actually errors out and brings me back to the VBA screen highlighting that line.