query By Form but Bring back everything as default

[kplatt]

Hi, I have a query by form where if I put in the year on the form the query brings back records related to that specific year. This is great and works, but as a default I would like all the data to come back. For example if I do not type any year in the form, all data from the original query will come back. Thanks

 

[pbaldy]

Does this work for you?

http://access.mvps.org/access/queries/qry0001.htm

 

[kplatt]

Yeah that worked. Thanks alot. I knew that had to be pretty easy.

 

[pbaldy]

Happy to help.