There are times I feel really dumb.
I want to create an on-call list of names and phone numbers from a master table of all personnel. I would like to type in the last name of a person and have the persons first name and telephone number filled in automatically. I can do this for one record with a form and linked sub-form, but cannot get it to work so I can print a list of six (or more) names and telephone numbers on one sheet of paper for posting on the notice board.
Please help. Thank you.