>I have a form based on a pview. The parameter is the name of a particular person which has their name in a record field. But suppose I want say and supervisor to use this form to get all the records of the table through the view. Is this possible?
For character fields, this is particularly easy. Just set the parameter to space(0) (or "", which is the same). Make sure you have SET EXACT OFF.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)