A paramater based on another paramater's results??

[Guest]

I have an employee list table including the standard fields first name, last
name, and others. I also have a query & report that return employee-specific
data through use of a simple paramater query asking the employee's last name.
Now I have two employees with the same last name, and I need a way to deal
with this because the report shows both employees data when that last name is
entered.

What I'd like is: when the paramater query for the report comes up asking
for the employee's last name, and if there are duplicate last names, to then
let me pick which employee from a drop-down, or notify me and ask me for a
first name, but only if there are duplicate last names in the table.

Any help would be appreciated, Thanks.

 

[Duane Hookom]

Do yourself and your users a favor and create a form with a combo box that
displays employee full names but is bound to the primary key from your
employee table. Then use this combo box to filter your report.