Macro to apply filter to form

[mattzkn]

Hi All,



I have no idea what i am doing with macro's, but i am fairly sure what i am trying to achieve is simple. I want a macro to apply two filters to a form "contact list"

First filter should only show records if field in column "hotlist?" is blank

Second filter should only show records if field in column "interested?" is blank or "Yes"

I will attach this macro to a button so when i click it, the form is only displaying results where there is no data entered in 'hotlist' AND there is either no data in 'interested' or the data entered says 'Yes'

How would i go about doing this?

Thanks alot!

Matt

[June7]

Is this form already open or do you want to open it with the filter applied? I don't use macros, only VBA, but I am sure either is possible with macro.

Are both fields text type?

[mattzkn]

Hi, thanks for your response.

The form will already be open, both fields are text.

[June7]

One approach is to set the Filter and FilterOn properties of the form. In VBA I would:

Me.Filter = "hotlist Is Null And (interested='Yes' Or interested Is Null)
Me.FilterOn = True

I don't know what the macro structure would be.