Re: form selection issue
Bob Barrows
> Hi,
>
> I have an access database that contains 5 years worth of data. The
> table names are in the format of 4 digit year and tags, i.e. 2007tags,
> 2008tags, 2009tags, etc.
<sigh> Bad design. Data should be stored in the rows of the table, not
in the names of the tables. The "year" is data that should be stored in
a column of a single "tags" table.
> 99.9% of the work will be querying against
> the current year. However there is the occasional needed to view past
> years. So I wrote some code that defaults to the current and asks the
> user if they want to change it. The problem is I can't get to the
> older data. The code always defaults to 2009. I really don't want to
> create a page of buttons and the user chooses 2009 because that would
> be extra work.
Why wouldn't you simply put a simple textbox that defaults to the
current year? Why are you thinking of creating all these buttons that
you would be having to change every year?
>
> The goal is to have the system default to the current year. When the
> user selects 2008 and clicks on submit the queries should run again
> against the 2008tags table.
>
> What did I do wrong?
>
I don't know. What symptoms are you seeing?
--
HTH,
Bob Barrows