Access 2000-Forms

[Rory Popa]

Hi,

I have a series of standardised forms that i want upon a
selected user value ie year and/or system date
synchronised will change the recordsource/tables for each
form. I am having trouble coding this to work, can you
help?

Thanks

Rory

 

[John Vinson]

Hi,

I have a series of standardised forms that i want upon a
selected user value ie year and/or system date
synchronised will change the recordsource/tables for each
form. I am having trouble coding this to work, can you
help?

If you have a different table for each year... *you have an
incorrectly normalized database* and will have continual problems with
it! Why not just store the date in the table, and use a parameter
query to choose the year? Am I misunderstanding the structure of your
tables?