Good morning all!
I'm struggling with a rather rudimentary issue. I have a form with 3 combo boxes as search fields. Each works fine, what I want to accomplish is if someone wishes to search for another record, I want the previous filter to be cleared and the combo boxes emptied. I have
which works fine as well. I have this currently on the Got Focus event of the field. (had it On Enter first). Both ways cause the need to click the drop down twice. So when you enter the field it clears everything and the drop down list disappears, and you have to choose it again. What am I missing? Should I put it somewhere else? Or do I really have to have a separate button to clear the filter and boxes? That would still require two clicks.Code:Me.Filter = "" Me.Combo69 = "" Me.Combo71 = "" Me.Combo73 = "" Me.WildProjectName = ""
Thanks in advance!!