Combining a Userform with Query

[mattydalton]

Hi all

I have designed a userform to enable users to be able to enter criteria into the relevant boxex that will then be planted into a lookup sheet and this will, in turn, update a query using these values as criteria.

I would like to be able to give the option for the user to not select one of these criteria and therefore cause the criteria not to apply when the query is updating. Anybody got any ideas?

Thanks

Matt

[Kenneth Hobson]

Set up different Criteria ranges and name them for your filter run or use the range in the filter.

If you are using a data query, other specifics would probably help.