Can I use form to reset a field's default value in a table

[louise]

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!

[ranman256]

don't set defaults on the table, set them on the form
(for just this reason)

[louise]

Well... I know that makes sense, but I have dozens of forms that would have to have this field added one way or the other, and the change only occurs twice a year.

Are there any other options?
Thanks

[CJ_London]

you may set the default in your table - and every form control you create after you have done this will pick the default. However controls that existed before you set or change the default will not be affected. So as ranman says, better to just set it in the form

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

whatever you do means going into all your forms and modifying them

To modify only once, what you can do is have a table of defaults. suggest needs fields tablename, fieldname and default value

so have a form for a user to update this

then in each form open event you need some code to lookup the default value and assign it to the relevant control

e.g. acontrol.defaultvalue=dlookup("default","tbldefaul ts","tablename='tblsomething' AND fieldname='" & acontrol.name & "'")

alternatively, perhaps the default can be set based on a calculation - you mention semester and year - can these be determined by a calculation based on the date function? If so - calculate and set it when the form is opened