Global Changes to Database

[JSDART!!]

Hi
I have created a database that keeps sports stats.
each season I clean out the database to start fresh I would like to automate that. I know how to setup the clearing of the tables.
what I need an assist with is this. there are multiple reports and forms in the database that have a heading stating the season that we are currently.
Does anyone know of a way to set up an update that will request what season and then replace it on all the objects that needs to be updated.
thanks
J

 

[pbaldy]

Presuming that the season can't be derived from the data, I'd put the season in a textbox on a "main menu" form (or any form that's always open), and have each of the other forms and reports get it from there.

 

[JSDART!!]

Thanks Paul
that works but now i need a sugestion to change the content of the text box on my switchboard with out having the user go into the design of the database. Anyone have an Idea on this
thanks
J

 

[pbaldy]

All kinds of ways. Could be something like this behind a button:

Forms!FormName.TextBoxName = InputBox(prompt:="Enter Season", title:="Enter Season)