My database has a date field, year field and numberfield. The number field is set with DMax which will reset to No.1 when the year changes. I want help on the following: For current year's records - The DB should use the current year's records only for actual working i.e. data entry, edit, search, print etc. For previous year's records - The DB should allow only search and print and NOT for data entry and edit. How can I achieve this. Please help.
