Prompt User for Criteria

[easadmin]

I am running Access 2003. I created a query that prompts the user for
the initials of a person saved in a field called primarysource. I
entered [Please enter the directors initials] in the criteria field.
This works fine.

Is there a way to allow to user to hit enter, or some other key so
they can retrieve all records in the field. IOW: Have the query return
all results in the table, not those related to a particular director.

I've read the online help and my access book but couldn't find
anything. I'm sure it's possible.

Thanks.

 

[fredg]

I am running Access 2003. I created a query that prompts the user for
the initials of a person saved in a field called primarysource. I
entered [Please enter the directors initials] in the criteria field.
This works fine.

Is there a way to allow to user to hit enter, or some other key so
they can retrieve all records in the field. IOW: Have the query return
all results in the table, not those related to a particular director.

I've read the online help and my access book but couldn't find
anything. I'm sure it's possible.

Thanks.

Change the SQL where clause from
Where [SomeField] = [Please enter the directors initials]
to
Where [SomeField] = [Please enter the directors initials] Or [Please
enter the directors initials] Is Null