Parameter query in Access

[smurf01]

I have a table in Access which contains a field called "completed" the purpose of the field is to show whether the record is complete or outstanding. The values are as follows
0 = outstanding
1 = completed
I have created a parameter query which asks the user which value to use, if the user chooses "0" then the query runs and if there are no records the query is blank, if this is the case they will then need to look for records that are complete,they then have to use "requery and enter the value of "1". What i would like to achieve is that i put some code in that firstly automatically queries for "0" but if there are no records it will automatically requery using the value of "1".

To further enhance this if the query uses "1" then it only displays the last 6 records entered

Hope I have not confused you too much

Please Note : I posted this question in the Office forum and it was suggested that i might want to try either here in the VBA forum or the Access forum

Regards

Paul