I have a combo box as part of my search query. After a search I want to be able to clear and do a fresh search. I have called the combo box TYPE. Because of this when I set up a button and put TYPE = NULL, it won't work. Access will not accept this as it is a keyword.
I do not wish to rename the field TYPE
I do not wish to rename the field TYPE
