Dates in the Query form - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Dates in the Query form

Philip Chong

3 years ago

Hi there,
I have made a query form which has an expiry date field.
When I select a date with a filter specifying that particular date and all the dates thereafter and press CTRL S, exit and double click to bring up that query again, the date filter has not been saved. All the dates in the field reappear. This also happens when I design a report. What am I doing wrong?

	Kevin Yip @Reply 3 years ago
To save a form's filter when you close, you need to set the "Filter On Load" property to Yes on the form's property sheet. Same with reports. When a filter is active, the bottom of the form should show "Record x of y, Filtered". Or "Unfiltered" if not.

	Philip Chong OP @Reply 3 years ago
Thank you Kevin. You have saved me lots of frustration and time. Cheers, Philip

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View