Hello,
I have a table with several default values (Semester and Year).
In the transition to the next semester/year, the user will delete the rows of several tables but maintain the table structure, ready for the new data entry in the next semester.
Is there a way to create a form that asks the user to enter the new semester and year -- and then have those values become the new default values of the fields (to be applied when new records are created.) (I don't want to ask that the person go into the design view of the table itself. I am hoping to do this with a form.)
Any suggestions?
Thanks!