Trying to add a textbox into an existing form that will update

[coxdpcl]

I have a form that when I open the database it automatically update to a new weekending date. I need to add another textbox to update to a new quarter when I open the database. How can I add this to an existing form.

[GKJR]

Try adding a text box and type "q" (without the quotes) in the format property on the Format tab and "Date()" in the default value on the Data tab. Even though q isn't on the drop down list Access automatically knows that this is the format for the 'Quarter in the Year' of a date value.