In my form I will be filtering by employeename, which will then print out a report A simple drop down menu, with a list of employees.
This filtering is being done to process owners which is a subform to the form that is being filtered. The process owners may have 1, 2, or 3 names in it.
Let's say I search for Doe, John. On most records he is the listed first as a process owner, however on some he is 2nd on the form. The report will show John Doe's name and then on record 45, it displays Mary Jones, who was listed first. The query in the recordsource is a groupby.
How can I do this so I get only the name that is selected?