Access 2000-Forms

  • Thread starter Thread starter Rory Popa
  • Start date Start date
R

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
 
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?
Click to expand...

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?
 
Back
Top