Query is modified when I run it (1 Viewer)

Hi,

I have a query based on two joined tables. There is a report based on the query. I had a parameter query set up where a user could enter a Job Number and the report would open up filtered for just that job number.
I want to have a list box on a form where the user can select a job number from the list box rather than have to remember them.
The problem is, when I run this the query is modified somehow. One of the tables that the query is based upon disappears from the query and all fields, except Job Number, are removed from the query.
Why would this happen?

Thanks very much
Dave

maybe on the previous thread you made, you will find the answer on those removed fields.

regarding the list.
don't to open the Report, but rather Open a pop up form that will then open your report.

create a pop up form with the list of your choice.
make this form Modal.
modify the pop up appearance through its property, without title bar, so user wont
be able to close the form except through a close button.
on the Close button click event, test first if there are selected item on the list.
if there is, Open your Report and pass a WhereClause to the
DoCmd.OpenReport method.