A
accessuser
hi,
I'm creating a database for my work and need some help on parameters. I have
a main table, where my queries are based on. I have many queries with
critiria of [enter year], and "department name"., and then I create each
department forms base on the department queries. When I open up my forms,
parameter shows up the parameter box [enter year], and I enter the year and
it gave me all the information i need.
Here is my question
When I am in the department forms, and try to do a "filter by form" to narrow
down records, the same parameter [Enter year] pop up twice. I can understand
it to show up once, but not two. Can someone explain this to me? Is there
any way to fix this problem?
Thank you.
I'm creating a database for my work and need some help on parameters. I have
a main table, where my queries are based on. I have many queries with
critiria of [enter year], and "department name"., and then I create each
department forms base on the department queries. When I open up my forms,
parameter shows up the parameter box [enter year], and I enter the year and
it gave me all the information i need.
Here is my question
When I am in the department forms, and try to do a "filter by form" to narrow
down records, the same parameter [Enter year] pop up twice. I can understand
it to show up once, but not two. Can someone explain this to me? Is there
any way to fix this problem?
Thank you.