C
cmiller
Greetings all,
I work at a company with an IT department, but they are so busy, they do not
have time for my trivial questions. I resort to the mass knowledge available
to me by you wonderful people.
I have a database of Issues entered by my agents. All of my agents have
their own data entry form ex. FrmJohnDoe, FrmJaneDoe, FrmJohnSmith. Each of
these forms automatically assign the agent name and date when the new record
is created.
All of these forms were created from the same table, TblMainData, that
records each issue with a customer. To normalize the table, a look-up
reference has consolodated the agents onto its own table TblSpecialist.
What I would like to do is When JohnDoe opens his form, I would like for him
to see only those issues he had entered into the log, i.e. Where fieldname
"Specialist"="John Doe".
I am using Access 2003. I have read online about using a query, creating a
macro, and using subforms. Since I am wanting this to be a constant,
everytime the form is opened, I also read the query method is not the best
method. Please advise how this task might be accomplished best?
I work at a company with an IT department, but they are so busy, they do not
have time for my trivial questions. I resort to the mass knowledge available
to me by you wonderful people.
I have a database of Issues entered by my agents. All of my agents have
their own data entry form ex. FrmJohnDoe, FrmJaneDoe, FrmJohnSmith. Each of
these forms automatically assign the agent name and date when the new record
is created.
All of these forms were created from the same table, TblMainData, that
records each issue with a customer. To normalize the table, a look-up
reference has consolodated the agents onto its own table TblSpecialist.
What I would like to do is When JohnDoe opens his form, I would like for him
to see only those issues he had entered into the log, i.e. Where fieldname
"Specialist"="John Doe".
I am using Access 2003. I have read online about using a query, creating a
macro, and using subforms. Since I am wanting this to be a constant,
everytime the form is opened, I also read the query method is not the best
method. Please advise how this task might be accomplished best?