I have a number of queries in which the WHERE criteria is an employees surname. However in two cases multiple employees share the same surname and the results are combined (e.g. Courses attended).
Each employee has a unique ID number (which I'd prefer to use) but my users prefer to use Surnames (easier to remember). Is it possible to request further criteria (i.e. ID number) only when multiple recordsets occur based upon the original one.
If I use a pop-up form how do I link the pop-up selection back into the query? I assume I have to run the SQL in some sort of VBA script linked to the form?
Also how do I get the form to only appear when multiple recordsets result?
Any pointers will be gratefully accepted.