Hi all. I have previously posted this thread on the Forms forum, but to no avail, so apologies to anyone who is reading this for the second time.
I have used the code within FAQ702-1177: Search multiple fields simultaneously and set form to record found many times over the years, in order to create a user search form. It has been invaluable.
My problem now is that my users require the form to enable them to search, on the same form, between two dates, as well as by text variables. MyCriteria is a string, so wheras the code will allow a search for a specific date, it will not allow a search on a value > MyCriteria or < MyCriteria.
I'm no expert in SQL, and my VBA is incredibly rusty. Is there a solution to this problem which isn't immensely complicated.
Any help, as ever, greatfully received.
I have used the code within FAQ702-1177: Search multiple fields simultaneously and set form to record found many times over the years, in order to create a user search form. It has been invaluable.
My problem now is that my users require the form to enable them to search, on the same form, between two dates, as well as by text variables. MyCriteria is a string, so wheras the code will allow a search for a specific date, it will not allow a search on a value > MyCriteria or < MyCriteria.
I'm no expert in SQL, and my VBA is incredibly rusty. Is there a solution to this problem which isn't immensely complicated.
Any help, as ever, greatfully received.
