Access

Hi Simon

When using parameter queries you always need to enter a value otherwise you get blank lists or errors.

To onercome this you should create your parameter using the wildcard. For example:

=[Please enter a Code] & "*"

This will allow you to leave the box blank and have the system return all values.

It also allows you to make a partial entry and have the computer return all values beginning with that

Hope this helps

Carlos