Microsoft Access Query Help

[1001011010]

I have a query in my database which searches for a specific record in the database using a parameter that the user enters. I also have a form bound to the query to display the record information for me. But there is a problem. If the user searches and enters a parameter that does not exist, when the form loads, it is completly blank! I was wondering if i could tell the query, even if it dosen't find anything, to display the blank fields. The SQL statement follows:

SELECT Master_Service.COMMENTS1, Master_Service.EMPTYBX_WB, Master_Service.WORKNUM, Master_Service.PROBLEM, Master_Service.RET_WBN, Master_Service.CALLRCVDAT, *
FROM Master_Service
WHERE (((Master_Service.COMMENTS1)=[Please Enter The Incident#]);


Help me please....

 

[BillRossDenver]

1. Bind the form to Master_Service.
2. Set to new record on open.
3. Give user a combo box of values from Master_Service.COMMENTS1 so they can always select a valid value.