improving form navigation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good day ladies and gentlemen,

I'm working on an issue tracker. It works using two forms.The first
forms is used by an admin to assigns different tasks to different people. The
second form contains a drop down featurig the name of all those who have been
assigned tasks. Clicking on a name opens a subform containing the specific
tasks assigned to that person. My biggest problems is that each person can
receive dozen of tasks and i would like a better way to navigate through them
then just going record by record. I tried using a list box that retrieves
records but the problem is that the list box displays ALL the tasks instead
of the tasks assigned to the person currently viewing the subform. Is there
any way to make this work?

Any help would be immensely appreciated!!
mat
 
mlagace said:
Good day ladies and gentlemen,

I'm working on an issue tracker. It works using two forms.The
first forms is used by an admin to assigns different tasks to
different people. The second form contains a drop down featurig the
name of all those who have been assigned tasks. Clicking on a name
opens a subform containing the specific tasks assigned to that
person. My biggest problems is that each person can receive dozen of
tasks and i would like a better way to navigate through them then
just going record by record. I tried using a list box that retrieves
records but the problem is that the list box displays ALL the tasks
instead of the tasks assigned to the person currently viewing the
subform. Is there any way to make this work?

Any help would be immensely appreciated!!
mat
Click to expand...

Have the query used by the ListBox refer back to the value on the form
containing the personID as a criteria.
 
Something Like

Query SQL:

SELECT Field1,.., FieldN FROM MyTable
WHERE Fieldx = Forms!MyForm!PersonID

HTH

Pieter
 
Excellent, I got it working just like i envisioned it! Thank you all very
much for your help!

Best regards,
mat
 
Back
Top