I have a database with student information that contains tables about their dissertation and graduation information. There is a field "academic year" noting their graduation year. I have a form for data entry that my data entry person likes to use in datasheet view. The form is based on a query that contains only current academic year records. When a new academic year arrives, I plan to create a new query for the form to feed from. I am not sure this is the best way to handle this, i.e., "hiding" past academic year records on the form in datasheet view.
Hope that makes sense.....
Thanks.