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