I have a parameter query that is launched from a form containing three unbound fields. The first two fields prompt for a date range and the third field prompts for a value [OfficeName]. The [OfficeName] field is a combo box that looks up values from [tblOfficelist]. I would like the query to accept either an [OfficeName] value or a Null value. If there is a Null value, then I would like ALL OfficeNames included.
Like [Forms]![HelpDeskDetailbyOfficeForm]![OfficeName] & "*"
and then created an additional column in the query set to:
[Forms]![HelpDeskDetailbyOfficeForm]![OfficeName] or Is Null
The strange thing is that when I run the query without the form and leave the [OfficeName] field blank it works great! But with the form, it gets hung up when formatting the page and I have to press Ctrl-Break.
Your help/ideas/suggestions is greatly appreciated.